Posted by das on 04/05/06 23:15

try this, I haven't tested it:

select A.ID, A.Name, Sum(B.TimeStamp)
from A inner join B on A.ID = B.ID
group by A.ID, A.Name
having (B.ChgCode <> 'S' and B.Description <> 'don''t care')

adi

• Next in forum: datetime diff query syntax
• Prev in forum: Calculate time lapse
• Thread view: Re: Calculate time lapse

[Reply to this message]