posted 18 years ago
Hello All,
I have below conditions:
I need to join 3 tables b,c,d where b.id=c.id and b.id_nbr = c.id_nbr and
b.id=d.id and b.id_nbr=d.id_nbr and d.state !=1 and
b.flag = 'some_value' and b.id = ? and c.roll_nbr = ?
the row will always be there in tables b and c ,but it's not necessary that the row will be there in table d. Even in that case the query should retrieve the row from tables b,c and do not apply d.state !=1 condition.
Which type of join needs to be used in above case?
Thanks,
Trupti