Quote:
Originally Posted by robinw
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.
|
I knew this query in SQL not in Access
Select Vendor.VendorName,Product.ProductCost from Vendor inner join Product on Vendor.v_code=Product.v_code where (Vendor.VendorName like '%Inc%') and (Product.ProductCost <=150)