Hi,
I have a parent/child pair of tables that I need a count of both instances.
The parent Contact Log has these fields
LogDate,LogTime,LogType
The child table has followup Calls to the parent.
LogDate,LogTime.
I need to count the instances of calls by Date and Time
Of inital calls and followup calls.
where LogType=1
I worked out the crosstab, but the counts are high.
I created a view with a Union like this
Select LogDate,LogTime,LogType
from Tab1
Where LogType=1
Union ALL
LogDate,LogTime,1 << Need 3 fields for the union
From Tab2
Is it the ALL that might be causing the problem? Or am I just off base with my approach?
Thanks Mike Davis
MSsql, VB and Crystal Reports Developer
I have a parent/child pair of tables that I need a count of both instances.
The parent Contact Log has these fields
LogDate,LogTime,LogType
The child table has followup Calls to the parent.
LogDate,LogTime.
I need to count the instances of calls by Date and Time
Of inital calls and followup calls.
where LogType=1
I worked out the crosstab, but the counts are high.
I created a view with a Union like this
Select LogDate,LogTime,LogType
from Tab1
Where LogType=1
Union ALL
LogDate,LogTime,1 << Need 3 fields for the union
From Tab2
Is it the ALL that might be causing the problem? Or am I just off base with my approach?
Thanks Mike Davis
MSsql, VB and Crystal Reports Developer