[RBG7-L] - Re: SQL Syntax

[Albert Berry]

If the same staff member has two evaluations in the period requested, 
you will end up with two or more rows.

Charles Parks wrote:
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.