Unsupported Screen Size: The viewport size is too small for the theme to render properly.

ERROR MESSAGE on SQL QURRIES

forums › forums › ERROR MESSAGE on SQL QURRIES

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 15, 2003 at 11:23 pm #13747
      Ritesh
      Member

      Which version of MySQL you are using?

      MySQL does not support sub-select which you are trying to use as of now. It is a planned feature for their future releases.

    • February 16, 2003 at 12:36 am #13748
      jhd67
      Member

      Using the last one from mysql.com

      what's my ulternative to writte this querries

      Thank you

    • February 16, 2003 at 2:00 pm #13749
      CalEvans
      Member

      Currently, your only alternative is to re-write your queries to use left joins. This solution will allow you to work around most situations where you would use a sub select in the where clause. (That's where the majority of them exist.)

      As for sub selects in the field list. I've never seen that done. I'm not entirely sure that's ANSI standard. MySQL is working towards ANSI93 compatibility. If it's not in the ANSI93 spec, it probably won't be in MySQL.

      FWIW, the last version of MSSQL and Oracle I worked with did not have this 'feature'.

      The other thing you can do is re-design your database so as not to require these. Not knowing your schema or problem space, I couldn't begin to suggest how. But you might want to take a step back. It might mean de-normalizing a bit.

      HTH,

      =C=

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.