Answers for "select on select sql"

sql select from select

SELECT t1.*
FROM   t1
WHERE  t1.MY_FIELD = (SELECT  t2.MY_FIELD
                   FROM    t2
                   WHERE   t2.MY_FIELD = t1.MY_FIELD);

Posted by: Guest on March-25-2021

select in select sql

SELECT column1 = (SELECT column-name FROM table-name WHERE condition),       column-names  FROM table-name WEHRE condition

Posted by: Guest on November-20-2020

Code answers related to "select on select sql"