>>select .... from Table1 left join Table2 on Table1.pk_field = Table2.pk_field >>>>
>CREATE CURSOR t1 (pk int autoinc, val C(10)) >CREATE CURSOR t2 (pk int autoinc, val C(1), fkT1 int) >CREATE CURSOR t3 (pk int autoinc, val C(2), fkT1 int) > >INSERT INTO t1 (val) values (SYS(2015)) >INSERT INTO t1 (val) values (SYS(2015)) >INSERT INTO t1 (val) values (SYS(2015)) > >INSERT INTO t2 (val, fkT1) VALUES ('A', 1) >INSERT INTO t2 (val, fkT1) VALUES ('B', 1) >INSERT INTO t2 (val, fkT1) VALUES ('A', 2) >INSERT INTO t2 (val, fkT1) VALUES ('A', 3) >INSERT INTO t2 (val, fkT1) VALUES ('B', 3) >INSERT INTO t2 (val, fkT1) VALUES ('C', 3) > >INSERT INTO t3 (val, fkT1) VALUES ('AA', 1) >INSERT INTO t3 (val, fkT1) VALUES ('BB', 1) >INSERT INTO t3 (val, fkT1) VALUES ('AA', 2) >INSERT INTO t3 (val, fkT1) VALUES ('AA', 3) >INSERT INTO t3 (val, fkT1) VALUES ('BB', 3) >INSERT INTO t3 (val, fkT1) VALUES ('CC', 3) > > >SELECT * FROM T1 JOIN (select MIN(val) as val, fkT1 FROM t2 GROUP BY fkT1) tt ON t1.pk = tt.fkt1 JOIN t3 ON t3.fkT1 = t1.pk > >Interesting. I have never seen the JOIN having the (SELECT MIN). I will try this code. Thank you.