-
SQL query to map data between 2 tables
Hi all,
I have a requirement where i need to check address is same in 2 tables. one is interface table & other one is a table in erp system. i need to write a query to map tables to check if the address is existing or not..Please help me out in doing this...
Its very urgent...
Thanks....
Deepthi..
-
Something like:
select * from tab1 where address in (select address from tab2)
select * from tab1 where address not in (select address from tab2)
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
|
|