Posted on 2006-05-28
Hi- This should be simple for you experts..I hope!
I am pulling results from two different tables. I want the results to relate to each other:
<cfoutput query="get_products" startrow=1 maxrows=1>#name#:</cfoutput>
<cfoutput query="get_products" startrow=1 maxrows=1>#description#</cfoutput>
<cfoutput query="get_prices" startrow=1 maxrows=1>#price1# #price2#</cfoutput>
But I want prices in the "get_prices" query to relate to the name and description in the "get_product" query. I'm sure I need a where clause in my second query, that says something like WHERE id (From table1) equals product_id (from table2). But I'm not sure how to do that. Is that clear enough? Thanks!!