Would this be the correct sql syntax to join two tables on StfMbr and where DateFinished would be after CEUTimePeriodFrom but before CEUTimePeriodTo?
select * from evaluations t1, StfMbrCEU t2 where t1.StfMbr = t2.StfMbr and t1.DateFinished between t2.CEUTimePeriodFrom and t2.CEUTimePeriodTo When I do a browse on it I some rows repeated.
