Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE tbl_new AS WITH tbl_alias1 AS (SELECT a, MAX(b) AS b, MIN(c) AS c FROM tbl1),
- tbl_alias2 AS (SELECT a, AVG(d) AS d FROM tbl2)
- SELECT tbl_alias1.*, tbl2_alias.* FROM tbl_alias1 JOIN tbl_alias2 ON tbl_alias1.a = tbl_alias2.a
Add Comment
Please, Sign In to add comment