TABLE_(WORKER)
   INT_     (ID) PRIMARY_KEY
   STRING_  (NAME, 200)
   STRING_  (LASTNAME, 200)
   INT_     (PLANT_ID)
END_TABLE


TABLE_(PLANT)
   INT_     (ID) PRIMARY_KEY
   STRING_  (NAME, 200)
   STRING_  (ADDRESS, 200)
END_TABLE

S_WORKER w;
S_PLANT p;

SQL * Select (w.NAME,w.LASTNAME,p.NAME,p.ADDRESS).FROM(WORKER).LeftJoin(PLANT).On(w.PLANT_ID==p.ID);

while SQL.Fetch() {
   Cout() << SQL[w.NAME] << SQL[w.LASTNAME] << SQL[p.NAME] << SQL[p.ADDRESS];
}