DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Select..... NOT IN

  1. 03-12-2004, 03:02 AM #1
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376

    Select..... NOT IN

    Hi,

    I have a combination of 3 columns are primary key on a table., Say Table A, column a,b and c as PK

    I need to select the data from Table A, by excluding the PK records which are already present in B.

    Since i have composite PK, i have problem in selecting.


    select * from A where PK not in (select PK from B)

    can somebody help me ?
    Last edited by bang_dba; 03-12-2004 at 03:06 AM.
    Reply With Quote Reply With Quote
  2. 03-12-2004, 03:36 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how about read some BASCI sql doco
    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