Adding mysql to the subject line would improve clarity and ease of classification.

It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -Original Message- From: adburne [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 2:47 PM To: [EMAIL PROTECTED]

problem with subquery

I am trying to do what seems like a simple Select: SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID 2) I know I this select is very simple, but I need to make this one work before I can tackle my 'real' query where the subquery is essential. I have MySQL version