|
View previous topic :: View next topic
|
| Author |
Message |
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
Hi,
I need an equivalent JOIN query for this below given sub-query.
| Code: |
SELECT ORDER_KEY, ORDER_NUM FROM DB01.CUST
WHERE NOT EXISTS (SELECT * FROM DB01.CUST_A
WHERE A.ORDER_KEY = B.ORDER_KEY)
|
Please help. Thanks. |
|
| Back to top |
|
 |
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
| You are checking for an order_key from CUST which is not present in CUST_A .. you can use NOT EXISTS or NOT IN but a join wont be possible .... |
|
| Back to top |
|
|
krithikaj
New User
Joined: 10 Aug 2008
Posts: 45
Location: India
|
|
|
|
Hi,
Try this SQL. Use the matching column names instead of selecting all the columns in the inner query.
SELECT ORDER_KEY, ORDER_NUM
FROM DB01.CUST
WHERE NOT EXISTS
(SELECT ORDER_KEY, ORDER_NUM
FROM DB01.CUST_A
WHERE A.ORDER_KEY = B.ORDER_KEY)
Thanks
K J |
|
| Back to top |
|
|
|
|
