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

By jonathan.krisda ·

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 conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Collapse -

sure, first do a make-table query

by Absolutely In reply to How to use a result from ...

Make your query based on item number into a make-table query. Then use a join on the two customer tables to select all items bought by the customers in the newly-made customer table.

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums