Welcome Guest, Not a member yet? Register   Sign In
SQL question / advice
#9

[eluser]Colin Williams[/eluser]
SELECT DISTINCT prod_id FROM products WHERE cat_id = "123" OR cat_id = "125"

EDIT --

Above SQL query misses the "match all" condition, among other things. Hard to assume your table structure, which would probably reveal a solution


Messages In This Thread
SQL question / advice - by El Forum - 10-23-2008, 12:06 PM
SQL question / advice - by El Forum - 10-23-2008, 01:11 PM
SQL question / advice - by El Forum - 10-23-2008, 01:20 PM
SQL question / advice - by El Forum - 10-23-2008, 01:24 PM
SQL question / advice - by El Forum - 10-23-2008, 01:47 PM
SQL question / advice - by El Forum - 10-23-2008, 01:53 PM
SQL question / advice - by El Forum - 10-23-2008, 01:56 PM
SQL question / advice - by El Forum - 10-23-2008, 02:25 PM
SQL question / advice - by El Forum - 10-23-2008, 07:50 PM
SQL question / advice - by El Forum - 10-24-2008, 02:24 AM



Theme © iAndrew 2016 - Forum software by © MyBB