List:General Discussion« Previous MessageNext Message »
From:Rich Brant Date:April 19 2005 7:05pm
Subject:mysql syntax
View as plain text  
I'm used to doing something simple such as the following in sql server:

SELECT     u.Username, p.UserID
FROM       Users u LEFT JOIN
           Person p ON u.UserID = p.UserID

However, I'm not seeing the same results in MySQL.  I don't get all
the recs in the users table and NULLs in the userID column from the
person table when the users.userID is not in the person table.  I get
no recs at all.  What am I missing here?

Thanks!
Thread
mysql syntaxRich Brant19 Apr
  • Re: mysql syntaxSGreen19 Apr
    • RE: mysql syntaxRich Brant19 Apr
      • RE: mysql syntaxSGreen19 Apr
      • Re: mysql syntaxgerald_clark19 Apr