Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Selecting items with another item in common
LifeinAsia - 3:21 pm on Oct 27, 2008 (gmt 0)
Try:
SELECT DISTINCT pCat
FROM YourTable
WHERE pID IN (SELECT pID FROM YourTable WHERE pCat=1)
Thread source:: http://www.webmasterworld.com/databases_sql_mysql/3773560.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com