Erwin Moller wrote:
SELECT U.userid, U.username, (SELECT G.groupname FROM tblgroup WHERE (G.userid=U.userid)) AS ingroup
typo, that should be 'tblgroup as G' of course.
FROM tbluser WHERE (bla..bla...);
------------------- Erwin Moller Darwine BV Groenendaal 25f 3011 SK Rotterdam tel 010-2133996 ------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
