create database foobar create table foo ( fkey i null, ffid1 c(1) null ) insert into foo values( 1, "a" ) insert into foo values( 2, "b" ) insert into foo values( 3, "c" ) create table bar ( bkey i null, bfid1 c(1) null ) insert into bar values( 1, "b" ) insert into bar values( 2, "c" ) insert into bar values( 3, "d" ) select * ; from foo inner join bar on ffid1 = bfid1 ; to screen * FKEY FFID1 BKEY BFID1 * 2 b 1 b * 3 c 2 c * select * ; from foo left join bar on ffid1 = bfid1 ; to screen * * FKEY FFID1 BKEY BFID1 * 1 a .NULL. .NULL. * 2 b 1 b * 3 c 2 c * select * ; from foo right join bar on ffid1 = bfid1 ; to screen * * FKEY FFID1 BKEY BFID1 * 2 b 1 b * 3 c 2 c * ,NULL. .NULL. 3 d * select * ; from foo outer join bar on ffid1 = bfid1 ; to screen * * FKEY FFID1 BKEY BFID1 * 2 b 1 b * 3 c 2 c * select * ; from foo left join bar on ffid1 = bfid1 ; union select * ; from foo right join bar on ffid1 = bfid1 ; to screen * * FKEY FFID1 BKEY BFID1 * .NULL. .NULL. 3 d * 1 a .NULL. .NULL. * 2 b 1 b * 3 c 2 c *