Please can i have multiple innner join statements in mysql??
tried to combine two but got a syntax error.
this is a sample of what i did
SELECT invoice.transid. invoice.airline, invoice.agent, airline.name, agent.name from invoice INNER JOIN airline, agent
WHERE invoice.airline=airline.name and invoice.agent=agent.name
Comments
You had a period after Invoice.transid instead of a comma
[code]
SELECT invoice.transid, invoice.airline, invoice.agent, airline.name, agent.name FROM invoice INNER JOIN airline ON invoice.airline = airline.name INNER JOIN agent ON invoice.agent = agent.name
[/code]
SELECT Fields FROM Table1 INNER JOIN Table2 ON Table1.Value = Table2.Value WHERE (Conditions pertaining to any table's values)
I removed the WHERE clause because it pertained to what you wanted your Inner Joins to do