Rich Brant wrote:

I forgot the important part: what I want is to filter on a userID in the
person table such as -


SELECT     u.Username, p.UserID
FROM         Users u LEFT OUTER JOIN
                     Person p ON u.UserID = p.UserID
WHERE     (p.UserID = 5) OR
                     (p.UserID IS NULL)

THis will return both the matching recs from the user table and NULLs from
the person table in sql server, but is what I cant get to work in mysql...



WHERE u.UserID = 5

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to