How to use a result from a query to prform another query? - TechRepublic
Question
December 11, 2007 at 04:41 PM
jonathan.krisda

How to use a result from a query to prform another query?

by jonathan.krisda . Updated 18 years, 7 months ago

Hi

I have a problem. I trying to create a database for buying pattern analysis. I have a set of table: customer and item. I want to create a query which will display, all the item that were bought by this customer who bought item ID p23541.
Which mean I need to set item ID p23541 as my main that lead to a specific customer and I want to know what else did he bought. So I imagine that I need to query? but can it be done

Thank you

This discussion is locked

All Comments