Creating a table using another two unrelated tables (postgres)

SELECT table1.attr1, table2.attr2 FROM table1 as table1 CROSS JOIN(SELECT attr2 FROM table2) as table2;

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.