Results 1 to 2 of 2

Thread: SQL query to map data between 2 tables

Hybrid View

  1. #1
    Join Date
    Oct 2007
    Posts
    3

    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..

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •