tamar hirshfeld
New member
- Local time
- Today, 04:15
- Joined
- May 9, 2014
- Messages
- 4
PARAMETERS report_header Text ( 255 );
SELECT [test db ab behav].[USER NAME], [test db ab behav].[SERVER NAME], [test db ab behav].date, [db ab hi-low].user, [db ab hi-low].server, [db ab hi-low].low_Event_no, [db ab hi-low].hi_event_no, count(*) AS event_count
FROM [test db ab behav], [db ab hi-low]
WHERE [test db ab behav].[USER NAME]=[db ab hi-low].user And [test db ab behav].[SERVER NAME]=[db ab hi-low].server and [event_count] >= [db ab hi-low].low_Event_no
GROUP BY [test db ab behav].[USER NAME], [test db ab behav].[SERVER NAME], [test db ab behav].date, [db ab hi-low].user, [db ab hi-low].server, [db ab hi-low].low_Event_no, [db ab hi-low].hi_Event_no;
my query works when I take the red part out !!!! but I need it (-:
SELECT [test db ab behav].[USER NAME], [test db ab behav].[SERVER NAME], [test db ab behav].date, [db ab hi-low].user, [db ab hi-low].server, [db ab hi-low].low_Event_no, [db ab hi-low].hi_event_no, count(*) AS event_count
FROM [test db ab behav], [db ab hi-low]
WHERE [test db ab behav].[USER NAME]=[db ab hi-low].user And [test db ab behav].[SERVER NAME]=[db ab hi-low].server and [event_count] >= [db ab hi-low].low_Event_no
GROUP BY [test db ab behav].[USER NAME], [test db ab behav].[SERVER NAME], [test db ab behav].date, [db ab hi-low].user, [db ab hi-low].server, [db ab hi-low].low_Event_no, [db ab hi-low].hi_Event_no;
my query works when I take the red part out !!!! but I need it (-: