Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: Filter out a table

    Stupid question

    I have a table called MAIN and a table called EXEMPT ACCOUNTS. I want to filter out the EXCEMPT ACCOUNTS table from the MAIN table- what is the easiest way to do this?

  2. #2
    Join Date
    May 2003
    Location
    New York, NY
    Posts
    225

    Re: Filter out a table

    Use a query

    SELECT Main.*, Exempt_Accounts.*
    FROM Exempt_Accounts LEFT JOIN Main ON Exempt_Accounts.AcctNum = Main.AcctNum;


    Good Luck

    Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •