On Thu, 3 Feb 2011 00:21:56 -0500, Igor Tandetnik wrote: > > select SUG.UserGrpID, SUG.GroupName, > coalesce(SUM.A_Link, 0), coalesce(SUM.B_Link, 0) from SecUserGroups SUG > left outer join > SecUserMembers SUM on (SUM.UserGrpID = SUG.UserGrpID and SUM.UserID = > 'Jane Doe');
Brilliant - just what this newbie was hoping for.... - thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
