scottybwoy Posted April 3, 2008 Share Posted April 3, 2008 What is the syntax when you want two AND clauses? This is my statement : SELECT TOP 1 modelId, productName, blurb, purchasing, technical, image FROM products AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(products.rrp) FROM products), 1) AS id) AS r2 ON r1.rrp >= r2.id AND endOfLine != 'TRUE' AND pSubTypeId LIKE 3% ORDER BY r1.rrp ASC Quote Link to comment https://forums.phpfreaks.com/topic/99342-and-and-and/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.