sql query select from 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;