Doh... Guess I spoke too soon. I get it now. I wasn't seeing a.CategoryID=b.ID
=) > -----Original Message----- > select a.ID > from products a, categories b > where a.CategoryID=b.ID and (b.ID='21' OR b.ParentID='21') -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
