• Home
• com.facebook.presto
• presto-product-tests
• 0.169
• source code
• join_postgres_to_postgres.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql-tests.testcases.connectors.postgresql.join_postgres_to_postgres.sql Maven / Gradle / Ivy

-- database: presto; groups: postgresql_connector; tables: postgres.public.workers_psql
--!
select t1.last_name, t2.first_name from postgresql.public.workers_psql t1, postgresql.public.workers_psql t2 where t1.id_department = t2.id_employee
--!
-- delimiter: |; trimValues: true; ignoreOrder: true;
null      | Mary|
Turner    | Ann|
Smith     | Ann|
null      | Martin|
Donne     | Joana|
Grant     | Kate|
Johnson   | Kate|
null      | Christopher|
Cage      | George|
Brown     | Jacob|
Black     | John|
null      | Charlie|