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.
|