List:General Discussion« Previous MessageNext Message »
From:Richard Morton Date:May 7 2003 1:31pm
Subject:re: Select in select
View as plain text  
Hi,

With any version before 4.1.x you are not able to do sub-selects as you have described
below.

4.1.0 is still in very early alpha testing.

To overcome this problem you can use programming logic, or, use a temporary table.

HTH

Regards,

Richard



 >>  Hy

 >>  I have Mysql 3.23 can i do a select in a select ?
 >>  something like

 >>  SELECT * FROM TABLE1 WHERE ( SELECT MAX(FIELD) FROM TABLE2 ) =
 >>  TABLE1.FIELD

 >>  Thanks
Thread
Select in selectBogdan Soos7 May
  • LoggingJerry7 May
  • Re: Select in select(Terry Riley)7 May
  • re: Select in selectEgor Egorov7 May
re: Select in selectRichard Morton8 May
  • Password Encryption...Doug Coning8 May
    • Re: Password Encryption...Jeff Shapiro8 May
      • Re: Password Encryption...Curtis Maurand12 May
        • a database design question....Bruce Douglas13 May
          • Re: a database design question....Becoming Digital15 May
  • Re: Password Encryption...Michael T. Babcock9 May
RE: a database design question....Bruce Douglas13 May
  • Re: a database design question....Bruce Feist14 May
    • RE: a database design question....Bruce Douglas14 May
      • Re: a database design question....Bruce Feist14 May
      • RE: a database design question....Curtis Maurand16 May
        • Re: a database design question....Bruce Feist16 May
        • Re: a database design question....Martin Gainty16 May
  • RE: a database design question....Curtis Maurand14 May
    • Re: a database design question....Michael Brunson14 May
    • questionRandy Paries14 May
  • RE: a database design question....Jennifer Goodie14 May
RE: a database design question....Bruce Douglas14 May