RE: Multi condition/table select

rchar Products: id=int 11 primary key name=varchar catid int 11 The query will then be evident. Mathias -Original Message- From: Andy Pieters [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 19:35 To: mysql@lists.mysql.com Subject: Multi condition/

Multi condition/table select

Hi all I am trying to figure out how to do this in one query. Using MySQL 2.3.58 Tables (only relevant data shown) Categories: id=int 11 primary key title = varchar Products: id=int 11 primary key name=varchar Lnk: catid=int11 primary key lnk=int 11 (key