• Home
• com.facebook.presto
• presto-product-tests
• 0.169
• source code
• join_mysql_to_mysql.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.mysql.join_mysql_to_mysql.sql Maven / Gradle / Ivy

-- database: presto; groups: mysql_connector; tables: mysql.test.workers_mysql
--!
select t1.last_name, t2.first_name from mysql.test.workers_mysql t1, mysql.test.workers_mysql 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|