RE: instead of subquery?

Try to build the following table: IDJOB | IDKIT | IDJOB2 4 | 19 | 4 4 | 19 | 4 4 | 19 | 4 4 | 19 | 4 4 | 19 | 2 4 | 19 | 2 2 | 19 | 4 2 | 19 | 4 2 | 19 | 2 2 | 5 | 2 (some join) Then throw lines with

Re: instead of subquery?

Hi, Hi. I have this table (A) IDJOB ¦ IDKIT 4 ¦ 19 4 ¦ 19 2 ¦ 19 2 ¦ 5 I need to extract IDKIT with IDJOB2 if and only if IDKIT IDKIT when IDJOB=2 In this case my query should return null With a subquery I can do this and it works SELECT idkit