Another Join query Problem

[seanybravo]

Sorry for anoter SQL query post I though that I was getting the hang of this:

SELECT tblData.*, tblTitle.*, tblCategoryList.* FROM ((tblData LEFT JOIN (SELECT * FROM tblTitle IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblTitle ON tblData.fldContactTitle = tblTitle.fldTitleID) LEFT JOIN (SELECT * FROM tblCategoryList IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblCustomCategory ON tblData.fldCategory1 = tblCustomCategory.fldID) ORDER BY fldCompanyName

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine does not recognize 'tblCategoryList.*' as a valid field name or expression.

Both tblTitle and tblCategoryList are in the Admin Database. The tblData link works fine so why am I having problems with the category list in the same location?

Thanks for any help.

 

[JerryKlmns]

SELECT tblData.*, tblTitle.*, tblCategoryList.* FROM ((tblData LEFT JOIN (SELECT * FROM tblTitle IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblTitle ON tblData.fldContactTitle = tblTitle.fldTitleID) LEFT JOIN (SELECT * FROM tblCategoryList IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblCustomCategory ON tblData.fldCategory1 = tblCustomCategory.fldID) ORDER BY fldCompanyName

tblCategoryList As tblCustomCategory

 

[PHV]

AS [!]tblCustomCategory [/!]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[seanybravo]

Great.

Thanks for your help.