I have a select, from, where, query set up. There are a number of "inner joins" in it as well.You need LEFT JOIN to get results for the lines that contain NULL values in the joined table.
Now what I noticed is if there are some null fields in
the records, nothing will get returned. If I remove
those particular joins (where the NULLS are), the
record is returned.
Does this sounds like a join issue ? The tables that are joined are "interpretive" tables. Meaning I store a 1 for Alabama in the main table. The States table I join has the 1 and then the associate label.
Stuart
http://dev.mysql.com/doc/mysql/en/JOIN.html
HTH, Wolfram
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
