Join query table references ADO Recordsets

[seanybravo]

I am opening a recoreset with this join query:

strSQL = "SELECT tblData.*, tblTitle.*, tblCustomCategory.* FROM ((((( tblData LEFT JOIN (SELECT * FROM tblTitle IN '" & adminPath & "') AS tblTitle ON tblData.fldContactTitle = tblTitle.fldTitleID) LEFT JOIN (SELECT * FROM tblCategoryList IN '" & adminPath & "') AS tblCustomCategory ON tblData.fldCategory1 = tblCustomCategory.fldID) LEFT JOIN (SELECT * FROM tblCategoryList IN '" & adminPath & "') AS tblCustomCategory1 ON tblData.fldCategory2 = tblCustomCategory1.fldID) LEFT JOIN (SELECT * FROM tblCategoryList IN '" & adminPath & "') AS tblCustomCategory2 ON tblData.fldCategory3 = tblCustomCategory2.fldID) LEFT JOIN (SELECT * FROM tblCategoryList IN '" & adminPath & "') AS tblCustomCategory3 ON tblData.fldCategory4 = tblCustomCategory3.fldID)"

I am having trouble referencing the table specific information for example

response.Write(rsCustom("tblCustomCategory1.fldDefinition"))

will not work. Is there a way of getting the information out of the Recordset?

Thanks

Sean

 

[PHV]

SELECT tblData.*, tblTitle.*, tblCustomCategory.* FROM
You select nothing from tblCustomCategory1 ...

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