Results 1 to 3 of 3

Thread: need a sql query

  1. Oct 27th, 2001, 02:44 AM #1
    parthi_75
    parthi_75 is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2001
    Location
    bkk
    Posts
    224

    need a sql query

    hi all
    i have 2 transaction table... code is a common field for both the tables, what i need is a sql query to compare and list out the codes which are not present at the both the tables, replies will be help ful
    cheers
    parthi
    Reply With Quote Reply With Quote
  2. Oct 27th, 2001, 03:27 AM #2
    007shahid
    007shahid is offline
    Fanatic Member 007shahid's Avatar
    Join Date
    Feb 2001
    Posts
    562
    SQL CODE:
    Code:
    Select * from table1, table2 where not table1.code=table2.code
    This will work only if there is atleast one row in both tables. Modify it as per your wish. You can also give table1.code or table2.code
    THE TIME/WEATHER IS
    Don't know how to use APIs or have problem with them,
    Download API-Guide & API-Viewer from http://www.allapi.net
    Reply With Quote Reply With Quote
  3. Oct 27th, 2001, 05:51 AM #3
    rjlohan
    rjlohan is offline
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    Not really sure if I follow your question, but try using the
    INNERJOIN parameter in your SQL query.
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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