List:General Discussion« Previous MessageNext Message »
From:John Morton Date:November 10 2001 12:53pm
Subject:Beginner SQL Question
View as plain text  
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 (08) 9451 6447
john@stripped

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

-T.S. Eliot  

Thread
Beginner SQL QuestionJohn Morton10 Nov
  • Re: Beginner SQL QuestionCarl Troein10 Nov
  • Re: Beginner SQL QuestionSteve Meyers10 Nov
  • Re: Beginner SQL QuestionBruce Ferrell10 Nov
  • Re: Beginner SQL QuestionShankar Unni10 Nov
  • Re: Beginner SQL QuestionNguyen Trong Phuc10 Nov
  • Re: Beginner SQL QuestionNguyen Trong Phuc10 Nov
  • Re: Beginner SQL QuestionShankar Unni10 Nov
  • Re: Beginner SQL QuestionNguyen Trong Phuc10 Nov