hello all,

I have a quick question... Im looking for a SQL statement to "JOIN" tables together in the one recordset.

I have two tables "products" and "productprice" - "products" hold the products information and "productprice" holds the costing. Now i need to call for a specials page the normal price and special price. So i created the below statement --

SELECT * FROM Products,Productprice
WHERE products.prodid = productprice.prodid AND prodspec = 'Y' AND productprice.custcat = 'Z' AND productprice.custcat = 'S'
ORDER BY products.prodshortdesc ASC

custcat Z = default price
custcat S = special price

Would anyone know how to call this record using the "JOIN" statement in SQL please?

Any solution would be appreciated

Thank you