Results 1 to 3 of 3
  1. #1
    udigold1 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2010
    Posts
    29

    Select statement not in same or another tab

    Hi,


    I have 2 tables:
    Table1 (equity_id,account_id)
    Table2 (equity_id,account_id)

    I need to find an equity that appears in table1 but does not appear on table2 with the same account_id

    Table1
    Equity_Id Account_id
    MSFT 123456
    Goog 123456
    F 567
    MSFT 231

    Table2
    Equity_Id Acount_id
    MSFT 123456
    Goog 123456

    Desired query result:

    Equity_Id Account_id
    F 567
    MSFT 231

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Sounds like a Find Unmatched query. Access has a query wizard for that.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    udigold1 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2010
    Posts
    29
    Thanks for the tip!
    I should have used two left joins from the get go.
    It works now

Please reply to this thread with any new information or opinions.

Similar Threads

  1. when (select statement within inner join should be used)?
    By learning_graccess in forum Programming
    Replies: 1
    Last Post: 05-17-2012, 01:54 PM
  2. Help with Select Case statement
    By focosi in forum Access
    Replies: 4
    Last Post: 08-09-2011, 12:01 AM
  3. Need a select statement
    By gahawy in forum Queries
    Replies: 5
    Last Post: 01-15-2011, 04:02 PM
  4. select statement
    By jellybeannn in forum Access
    Replies: 5
    Last Post: 08-13-2010, 05:21 AM
  5. What is wrong with my SQL Select statement?
    By John2810 in forum Programming
    Replies: 2
    Last Post: 04-01-2010, 10:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums