>>CREATE CURSOR x (a i,e i) >>CREATE CURSOR y (b i,f I) >> >>INSERT INTO x VALUES ( 1,2 ) >>INSERT INTO x VALUES ( 2,3 ) >> >>INSERT INTO y VALUES ( 1,1 ) >> >>SomethingCondition = "Y.f IS NULL" >>SELECT * FROM X LEFT JOIN Y ON X.a = Y.b WHERE &SomethingCondition >> >>SELECT * FROM X LEFT JOIN Y ON X.a = Y.b AND &SomethingCondition >> >>SELECT * FROM X JOIN Y ON X.a = Y.b AND &SomethingCondition >>>