I am the process of converting my companies applications from MS SQL to mySQL. It is all going OK, however I am having trouble with the following query:
SELECT Member.memberid, Member.mcname, Member.msname, UAGroup.groupname, UAGroup.groupid, Member.buid FROM UAGroup INNER JOIN UAMemberOfGroup ON UAGroup.groupid = UAMemberOfGroup.groupid RIGHT OUTER JOIN Member ON UAMemberOfGroup.memberid = Member.memberid WHERE Member.mpassword IS NOT NULL AND Member.musername IS NOT NULL The idea is to bring back all members and any groups they happen to belong to. In MS SQL the query brings back all members and has NULL entries for groupid if they are not in a group. In mySQL the query brings back all members, each of whom has an entry for each groupid. Any one have any idea how I can make the query perform as it does in MS SQL? Thanks in advance, Lewis -- Lewis Smith @ Work --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
