USE tpch1;
select * from sub1 LEFT OUTER JOIN (select * from sub2) Meal on(sub1.c1=Meal.c1 and sub1.c2=Meal.c2) order by 1;
c1	c2	c3	s1	s2	s3	c1	c2	c3	s1	s2	s3
1	1	1	1	1	1	1	1	1	1	1	1
2	2	2	2	2	2	NULL	NULL	NULL	NULL	NULL	NULL
3	3	3	3	3	3	NULL	NULL	NULL	NULL	NULL	NULL
4	1	1	1	1	1	NULL	NULL	NULL	NULL	NULL	NULL
5	99	99	99	99	99	NULL	NULL	NULL	NULL	NULL	NULL
6	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL