Creation consists of a SELECT statement within a FROM clause of another SELECT statement, such as in this example:

SELECT a.<column 1>, a.<column 2>, b.<column 1>
FROM <table 1>a, (SELECT <column 1 or expression>, <column n or expression> FROM <table 2> GROUP BY column 1) b
WHERE a.<column 3> =b.<column 1>