Compare value from one table to another table

[offdarock]

<cfquery datasource=&quot;offdarock&quot; name=&quot;qViewThreads&quot; dbtype=&quot;oledb&quot;>
SELECT name, email, date, subject, messageId, updated
FROM forums
ORDER BY updated desc
</cfquery>
<cfquery datasource=&quot;offdarock&quot; name=&quot;qViewThreadsResponse&quot; dbtype=&quot;oledb&quot;>
SELECT threadId
FROM forumsResponse
WHERE threadId = messageId
</cfquery>

this is the line I am having trouble with

WHERE threadId = messageId

the messageId is from the first Query...how do I compare them

Craig

 

[sgdragon78]

You can try this method:
<cfquery datasource=&quot;offdarock&quot; name=&quot;qViewThreads1&quot; dbtype=&quot;oledb&quot;>
SELECT name, email, date, subject, messageId, updated
FROM forums
ORDER BY updated desc
</cfquery>

<cfquery datasource=&quot;offdarock&quot; name=&quot;qViewThreadsResponse&quot; dbtype=&quot;oledb&quot;>
SELECT threadId
FROM forumsResponse
WHERE threadId = '#qViewThreads1.messageId#'
</cfquery>

 

[offdarock]

it works..thanks