Results 1 to 2 of 2
  1. #1
    mothermugger is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Nov 2011
    Posts
    1

    mutiple joins

    I have never had the real need for complex joins like I do for this project

    here is my simple problem that is now complex due to the need for the joins

    Deals Table: seller1ID seller2ID Buyer1ID Buyer2ID

    all Buyers and sellers (and a few others) are in the Players Table which has
    a key field called ID

    so I need mutiple joins something like this:

    SELECT * FROM deals
    INNER JOIN Players ON deals.seller1 = Players.id
    INNER JOIN Players ON deals.buyer1 = Players.id
    INNER JOIN Players ON deals.seller2 = Players.id
    INNER JOIN Players ON deals.buyer2 = Players.id

    This is a web project using Access DB
    I am using VBscript in classic ASP
    Not that that make much difference
    in the syntax of the SQL - I have seen
    a few examples but I can't get anything to work



    This is a line of code that creates the SQL from my project it works
    but I need add the multiple joins.

    sql = "SELECT * FROM (deals INNER JOIN Players ON deals.seller1 = Players.id) "

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    Do I understand this right?

    For every Deal you may have one or more Players?

    Every Player may be involved in one or more Deals?

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

Similar Threads

  1. Replies: 7
    Last Post: 12-03-2010, 11:09 AM
  2. Replies: 7
    Last Post: 10-08-2010, 09:48 AM
  3. Validating mutiple entry in a subform
    By Grooz13 in forum Forms
    Replies: 1
    Last Post: 08-09-2010, 06:53 AM
  4. auto populate mutiple fields
    By jomoan58 in forum Access
    Replies: 1
    Last Post: 07-23-2010, 01:03 PM
  5. Searching mutiple tables
    By mbolster in forum Access
    Replies: 8
    Last Post: 07-06-2010, 10:16 AM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums