On Tuesday 08 September 2009 04:34:00 pm Ed Leafe wrote: > select b.pkid , b.lname,b.fname , d.name_1 > from esattend a > left join esclient b on b.pkid = a.clientid > left join esenroll c on a.enrollid = c.pkid > left join escourse d on d.pkid = c.fk_escourse > where a.sessionid = 4596 > group by b.pkid, b.lname, b.fname, d.name_1 > order by b.lname
OK I'll try it. The only issue is there always more to it -right!. But in general I want the use of a bizobject and I'll use filters for the rest - I think I can. Johnf _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/200909081812.16615.jfabi...@yolo.com