Beginner SQL Question

[John Morton]

Hi,

Can someone tell me why this will not work, please

SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);

(Table and column names changed to protect the innocent, "15" could be a
variable or anything)

I thought this was just a common or garden 'Inner Query'. I
Have a feeling this has to do with the fact that I have to 
use different syntax for MySQL. I'm no SQL guru. Could someone please 
Point me in the right direction.

Thanks in anticipation,

john

++++++++++++++++++++++++++++++++++++++++++++
John Morton
http://www.jdmorton.com
Australia [phone]
john@stripped

Where is the wisdom we've lost in knowledge.
Where is the knowledge we've lost in
information?"

-T.S. Eliot