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 Link to comment https://forums.phpfreaks.com/topic/99342-and-and-and/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.