View Single Post
  #1 (permalink)  
Old 08-04-2007, 04:53 AM
robinw robinw is offline
Junior Member
 
Join Date: Aug 2007
Posts: 1
robinw is on a distinguished road
Unhappy ANY dialect question:

Incorporated vendors products less than $150


I am using MS Access 2003 and the question is: List all the products offered by Incorporated vendors(i.e. those vendors who have the word "Inc" in their name) and which cost less than $150. I have to have the following columns: Vendor Name, Product Description, and Product Price. This is a join, I think, because the vendor table is separate from the product table and have a common link, which is the v_code. Help Please.
Reply With Quote

ANSWER(S):