CREATE CURSOR taba ( ; > ID C(4), ; > field1 C(10), ; > field2 C(1) ; > ) > >CREATE CURSOR tabb ( ; > ID C(6), ; > field3 C(1) ; > ) > >INSERT INTO taba VALUES( "0101", "desc 1", "") >INSERT INTO taba VALUES( "0201", "desc 2", "X") > >INSERT INTO tabb VALUES( "010101" ,"1") >INSERT INTO tabb VALUES( "010102" ,"2") >INSERT INTO tabb VALUES( "010103" ,"3") >INSERT INTO tabb VALUES( "020101", "1") >INSERT INTO tabb VALUES( "020102", "2") >INSERT INTO tabb VALUES( "020103", "3") > ># 1 >select * from tabb ; > LEFT join taba on left(tabb.id,4)=taba.id ; > WHERE not empty(taba.field2) ># 2 >select * from tabb ; > LEFT join taba on left(tabb.id,4)=taba.id ; > WHERE EMPTY(taba.field2) >