SQL question / advice

SQL question / advice

10-23-2008, 01:11 PM

[eluser]Mike Ryan[/eluser]
Interesting... this should do it:

Code:
select prod_id from table where cat_id='123' and prod_id in (select prod_id from table where cat_id='126')

I haven't tested it yet, let me know how it goes.

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