SQL Statement - Inner Join problems

Hey All

Can anyone tell me whats wrong with this:

strSQL = "SELECT tbl_History.*, Employees.*, tbl_Vehicles.* FROM tbl_History INNER JOIN Employees ON (tbl_History.EID = Employees.Employee_ID) INNER JOIN tbl_Vehicles ON (tbl_history.VID = tbl_Vehicles.Vehicle) WHERE tbl_History.EID = " & eid & ""

It returns no records when there is a record it should be returning.

I have a feelign it's because of the WHERE statement.
What i want it to be doing is Joining the 3 tables.
Showing records that match the EID from the History table.

ideas
cheers
b :)

Hi,

You are definately sure that there are matching records in all tables?

Try taking out the where clause and see whether it returns the correct results, then see whether id you are sending matches correctly.

Last try would be to use left joins... :D


Vince