With Clause (CTE)

WITH a AS (SELECT * FROM some_table), a1 AS (SELECT * FROM some_table2) SELECT * FROM ( SELECT * FROM a ) b JOIN ( SELECT * FROM a1 ) c ON b.id = c.id

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.