Results 1 to 2 of 2

Thread: Cant figure out a query for...

  1. #1
    Join Date
    Nov 2008
    Posts
    2

    Cant figure out a query for...

    doing the following:

    I have 3 tables that I needing to pull some data out of. The primary key is Account_Num.

    Table1 - Contains all the accounts that I need to pull a list from where tot_val > 750000

    Table2 & Table3 - These contain various amounts of information for the accounts that I got from Table1. Some of the accounts from table1 may not contain values in table2 & table3. I need to pull the result set together, so I ultimately see something like:

    account_num tot_val tax_amt owner_name owner_address num_rooms num_bathroom


    Example of Tables:
    --------------------------------------------
    Table1 (T1)
    account_num tot_val
    ---------------------------------------------
    Table2 (T2)
    account_num tax_amt owner_name owner_address
    ---------------------------------------------
    Table3 (T3)
    account_num num_rooms num_bathroom
    ---------------------------------------------

  2. #2
    Join Date
    Nov 2008
    Posts
    2
    I am thinking I may need to use some outer joins. anyone?

Posting Permissions

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