#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,675
    Rep Power
    171

    Are correlated subqueries allowed in the FROM clause of a query?


    Are correlated subqueries allowed in the FROM clause of a query?

    Please provide examples if anyone knows the answer. Thanks
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,959
    Rep Power
    1014
    3 seconds:

    Originally Posted by http://dev.mysql.com/doc/refman/5.6/en/from-clause-subqueries.html
    Subqueries in the FROM clause cannot be correlated subqueries, unless used within the ON clause of a JOIN operation.
    The 6 worst sins of security ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".

IMN logo majestic logo threadwatch logo seochat tools logo