query help (1 Viewer)

[nelslynn]

I need a query that will provide the names of two employees from the employee Table where the employee ID's are in another table. I am doing this in code, so the query cannot query another query.

EmployeeTable: empID, empFName, empLName
TeamTable: empID1, empID2

Thanks

 

[namliam]

strSQL = "select * " & _ 
"from "  & _ 
"(teamTable left join "& _ 
"EmployeeTable as Emp1 on empID1 = Emp1.EmpID) Left Join "& _ 
"EmployeeTable as Emp2 on empID2 = Emp2.EmpID "

That should do the trick...

Regards

The Mailman

 

[nelslynn]

Thanks, but I get a error message "Join is not supported".
I'm using VB.NET

 

[namliam]

It is Access SQL, am unsure as to the syntax in VB.net ...

The query in itself is correct...

Sorry for not beeing any further help...

Regards