That example you point to uses *exactly* what I said you should use :
strSQL &= "FROM Employees INNER JOIN "
strSQL &= "Orders ON Employees.EmployeeID = Orders.EmployeeID INNER JOIN "
strSQL &= "Customers ON Orders.CustomerID = Customers.CustomerID INNER JOIN "
strSQL &= "[Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN "
strSQL &= "Products ON [Order Details].ProductID = Products.ProductID "
strSQL &= "WHERE Employees.EmployeeID = " & x & " ORDER BY orderdate DESC"
Juan T. Llibre, asp.net MVP
aspnetfaq.com :
http://www.aspnetfaq.com/
asp.net faq :
http://asp.net.do/faq/
foros de asp.net, en español :
http://asp.net.do/foros/
===================================
"Vili" <tu***@eitoimi.fi.invalid> wrote in message news:44***********************@news.fv.fi...
Juan T. Llibre wrote: That is done in the SQL statement.
You need to JOIN on the key field present in both tables.
But that would just get me
William Tom 01
Lorens Jack 02 Info Info Info Info Info Info
Lorens Jack 02 Info Info Info Info Info Info
Lorens Jack 02 Info Info Info Info Info Info
Nash Mike 03
or?
Here is an example what I found http://www.standardio.org/article.aspx?id=155
But I had some problems with that.