-
Hi
Incase I want to check out the presence of two columns in a table how do I do that .
select (ordernum,date ) from table_name A where (order_num,date) in (Select (order_num,date) from table_name B.
Gives me an error
and
if I write
select (ordernum,date ) from table_name A where exists (Select (ordernum,date ) from table_name B) gives me all orders and treats order_num and date as seperate columsn .
Please help
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|