Results 1 to 2 of 2
  1. #1
    access_user123 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    2

    Multiple Joins in multiple tables

    Hi,

    I'm relatively new to Access and I'm trying to write a query here. i have 3 tables:

    Table 1
    Code:
               P_id
             Name
             email
             S_id
                 1
             Abc
             abc@abc
             a
                 2
             Def
             def@def
             b
                 3
             Ghi
             ghi@ghi
             c
    Table 2


    Code:
               P_id
             Company
             Address
                 1
             Abc company
             Abc’s address
                 2
             Def company
             Def’s address
                 3
             Ghi company
             Ghi’s address
    Table 3
    Code:
               S_id
             Country
             Ph. No.
                 a
             USA
             12345
                 a
             Spain
             11111
                 a
             India
             98945
                 b
             India
             67890
                 b
             Spain
             22222
                 b
             USA
             77777
                 c
             USA
             75757
    Output:
    Code:
               Name
             email
             Company
             Address
             India
                 Abc
             abc@abc
             Abc company
             Abc’s address
             98945
                 Def
             def@def
             Def company
             Def’s address
             67890
               Ghi
          ghi@ghi
          Ghi   company
          Ghi’s   address
             
       
       
       
       
      
    So, I need details of Ghi user also even if it does not have India phone number and have India as a column header. Is that possible? Can someone tell me how the query will look like?

    Thanks! Do let me know if you need any information.
    Last edited by access_user123; 06-22-2011 at 02:50 AM. Reason: formatting

  2. #2
    access_user123 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    2
    Apologies for the horrible table formatting. I'm not able to do anything better than that!

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

Similar Threads

  1. Replies: 4
    Last Post: 06-14-2011, 07:19 PM
  2. Multiple Tables
    By Jeriko in forum Access
    Replies: 0
    Last Post: 03-08-2011, 11:40 PM
  3. Multiple joins, avoiding cross joined result
    By richjhart in forum Queries
    Replies: 2
    Last Post: 09-17-2010, 09:32 AM
  4. Multiple outer joins - error message
    By Lipi in forum Queries
    Replies: 1
    Last Post: 09-16-2010, 02:44 PM
  5. From with multiple tables
    By Darth_Katarn in forum Access
    Replies: 1
    Last Post: 09-23-2009, 08:17 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