July 29th, 2011, 07:16 AM
Join Date: Jul 2011
Time spent in forums: 42 m 53 sec
Reputation Power: 0
Two table query within query
I have two tables (Access DB), one with product info, other with manuals info like this:
Cat CDproduct Desc
1234 1001 Product 1001 belonging to Cat 1234
1234 1002 Product 1002 belonging to Cat 1234
5678 1010 Product 1010 belonging to Cat 5678
5678 9999 Product 9999 belonging to Cat 5678
Cat = Product Category, CDproduct = Product Code Indentifier
So in above table there is no manual for product 9999
I made a query to get a result matching "Cat", this works fine.
Now I want to use a single query on "CDproduct" comming from the original query "Cat"with a result that outputs Table one with a match on "Cat" and table 2 with a match on CDproduct, in other words, result should be products from table one, together with manuals from table two (if there is a manual found in table 2). Also products without manuals should be listed.
Any help in any direction is welcome.