query doesn't return records if field is missing 1

[skyline16]

I have a query that is composed of fields from several tables. Occasionally, a record will not have data for one or two of the fields in the query. If this is the case, the record is not returned when the query is run. It's not that the field for that record is just blank, it doesn't even have a place in the table so using "or is null" doesn't work. How can I make the query return these records?

 

[AlexCuse]

Sounds like you have an INNER JOIN that you need to change to a LEFT JOIN.

Have a look at this:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom