we can use subselect now with MySQL-Max version. ----- Original Message ----- From: "Steve Meyers" <[EMAIL PROTECTED]> To: "John Morton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, November 10, 2001 8:13 AM Subject: Re: Beginner SQL Question
> On Sat, 2001-11-10 at 05:53, John Morton wrote: > > Hi, > > > > Can someone tell me why this will not work, please > > > > SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = > > 15); > > > > There are no subselects in MySQL (yet). However, they're usually a bad > idea anyway, which is why it's never been such a big rush to get them > in. In this case, you'd be better served by a join. Try: > > SELECT tbl1.* FROM tbl1, tbl2 WHERE tbl1.column = tbl2.column AND > tbl2.intcolumn = 15; > > Steve Meyers > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php