Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

which join to use?

 
trupti nigam
Ranch Hand
Posts: 627
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Trupti,
You can use a subquery that checks for the state being equal to one. Then check that nothing exists in the subquery.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic