Results 1 to 3 of 3

Thread: Exclusive Selection

Threaded View

  1. Sep 3rd, 2007, 08:19 AM #1
    RS_Arm
    RS_Arm is offline

    Thread Starter
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 2007
    Location
    Planet Earth
    Posts
    282

    Exclusive Selection

    Hello.
    I'm working with a access v.2 database.

    This are 2 tables from where I need to collect some data:

    Table Account
    |ID|Name
    |1 |James
    |2 |Stewart
    |3 |Bill
    |4 |Bob

    Table AccountTMP
    |ID|
    |1 |
    |4 |

    The fields ID are PK on both tables.

    How do I select the data not existing on the AccountTMP table (ID=2, ID=3), based on the Account fields?

    Thank you.
    Last edited by RS_Arm; Sep 3rd, 2007 at 08:52 AM.
    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