from select sql code example
Example 1: 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);
Example 2: SELECT FROM
SELECT * FROM Customers;
Example 3: select in select sql
SELECT column1 = (SELECT column-name FROM table-name WHERE condition), column-names FROM table-name WEHRE condition