select ; timeuserscnames.lastname , ; timeuserscnames.frstname , ; weektime.assoc_id , ; weektime.workdate , ; weektime.worktime , ; weektime.aprvhrs ; ; from force ; ttreporter!weektime left join ttreporter!timeuserscnames ; on timeuserscnames.assoc_id = weektime.assoc_id ; ; ; where ; weektime.workdate > {^2000.01.01} ; ; order by ; timeuserscnames.lastnameNow I have to add in a column from a 3rd table, and join it to the weektime table on the taskname column. No matter what I seem to do, I get a Cartesian Join condition and get 1 billion or so records.
select ; timeuserscnames.lastname , ; timeuserscnames.frstname , ; timeuserscnames.assoc_id , ; weektime.workdate , ; weektime.worktime , ; weektime.projname , ; weektime.projstep , ; weektime.taskname , ; projtask.blineid ; ; from ; ttreporter!weektime left join ttreporter!timeuserscnames ; on weektime.assoc_id = timeuserscnames.assoc_id ; left join projtask ; on projtask.taskname = weektime.taskname ; ; ; where ; weektime.workdate > {^2000.01.01} ; ; order by ; timeuserscnames.lastnameHelp?!