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 4.1.0 alpha Thank you all in advance!