Hi,

I have a SQL statement on 3 tables! When one of table in this
statement have no record (return) null, I get a result of SQL
statement all fields null!!! How to set SQL to get fields which is not
null?

Here is the statent:

SELECT T1.Price, T1.Qty, T2.CPrice, T3.Pricex
FROM Table1 T1, Table2 T2, Table3 T3
WHERE T1.id = T2.Article AND T3.Article = T2.Article AND T2.Article =
:ARTICLE

Thanks