Topic: very simple query

[Miko]

Hi,

I'm trying to create a query that will get data from t1 and if not found go search in t2.

I have this for the moment:

Code: [Select]

SELECT * FROM tbl1, tbl2 WHERE tbl1.clnr = '$clnr' OR tbl2.clnr = '$clnr'
This kinda works but Instead of receiving 1 result I get the same result 100 times.

Anyone an idea? thanks

[fenway]

You can't do that -- that' a cartesian product.

You need to JOIN the two tables, and then, depending on what's in that column, use COALESCE().