"Harlan Feinstein" <[EMAIL PROTECTED]> wrote: > I've joined them an SQL statement that looks like this: > > select val, status > from A > left outer join B on val=id; > > What I'd LIKE is a 90-row result set, with the "status" field from table B > when there was data available. What I'm getting is essentially an INNER > join, only returning me 2 rows.
The following should work (and is probably the same as the syntax you used). If the datatype of id is numeric and that of val is character then it might not work. I believe the joined fields will need to be of the same type. Are they? SELECT val, status FROM A LEFT JOIN B ON val=id -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ --------------------------------------------------------------------- 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
