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) "