sql

[saku]

do i have to join tables by join command or i can do this:

... where (a.id2=b.id1) and (b.id2=c.id1) and (c.id2=d.id)...

thanx

[jackinva]

Assuming that before your where line you've got:

from a,b,c,d

then it will work. However, it will only return a dataset for records that all have the same primary key in ALL the tables. If you want to have the join work when there is null data in one of the tables, then you should be using LEFT JOINs instead.