Query not finding all data

[Idris01]

Good morning all, i have a query which should pick up all records relating to a given Identifier (5 digit number). for some reason the records returned do not inlcude any in which certain fields have either a null or 0 value. I cannot work out why but i need to ensure the query returns the data even if one or more fields in the record are null or 0.

any suggestions would be welcome

Idris

 

[Galaxiom]

i have a query which should pick up all records relating to a given Identifier

The query returned exactly the records that it should. Please don't mistake your lack of understanding as abberant behaviour of the query.

Without more information about the detail of the query it is difficult to suggest where you have made the mistake.

The most common problems are using an Inner Join where an Outer Join is required or expecting:

WHERE fieldname <> somevalue

to return records where there is no value in fieldname.

 

[Idris01]

Thanks for the swift kick in the rear, it was indeed a join error, i changed it and all is fine now.