I'm having difficulty doing a LEFT OUTER JOIN, and was hoping someone could shed a little light on what I'm doing:
Table A has one column, "val", that's an integer. There are 90 records, with values of "val" from 1-90. Looks like this: val --- 1 2 . . . 90 Table B is more sparse, with 2 columns: id status -- ------ 2 Good 4 Bad 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. What am I doing wrong? --Harlan --------------------------------------------------------------------- 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
