Re: SubSelect Problem

2002-03-18 Thread Alex Speed
Ok, no support for it (d'oh), so, how do I go about breaking it down into a join or something like that? - Original Message - From: "Alex Speed" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 12:13 AM Subject: SubSelect Probl

SubSelect Problem

2002-03-18 Thread Alex Speed
SELECT textid, title, description from structure where textid in (select subtopicid from subtopic where topicid='Top'); this gives an error at the opening bracket.. I am assuming that mysql realises that structure.textid=subtopic.subtopicid ...any ideas on getting this working? thanks for any