display records

[sql]

Hi all,
I have 3 evenAction tables , Neswlog, eventLog, formLog , they all have
id, sessionID, ind , subject , session ID
and I also have id , sessionID in Login page , I want to display every action on each sessionID, how to do that?
I use access 2007
________
Volcano digital vaporizer

[skhanal]

Join all three tables.

select <field list>
from table1
join table2
on ...
join table3
on ...

[sql]

I get error
SELECT FormLog .userAction, FormLog .actionTime ,FormLog.sessionID,
tEventdelete .userAction, t Eventdelete .actionTime, t Eventdelete.sessionID,
tNewsLog .userAction, tNewsLog .actionTime, tNewsLog.sessionID , LoginLog.sessionID ,
FROM FormLog , t Eventdelete , tNewsLog, LoginLog
Where FormLog.sessionID= LoginLog.sessionID
And Eventdelete.sessionID = LoginLog.sessionID
And tNewsLog.sessionID = LoginLog.sessionID
Groupby sessionID
________
Universal health

[sql]

I modify my sql code, but the display still not on hundred percent I want ,
I want every sessionId and it's action
1) may did not have action
2) have action on news, event, form,
3) only have action on any of the news, event or form
we use access 2007 for this parject, so is that possible to use store procedure?

SELECT userAction, actionTime, LoginLog.sessionID,  tNewsLog.username,  tNewsLog.IPaddress
FROM tNewsLog  Inner JOIN LoginLog ON tNewsLog.sessionID  = LoginLog.sessionID
union   
SELECT userAction, actionTime, LoginLog.sessionID, tEventDelete.username, tEventDelete.IPaddress
FROM  tEventDelete Inner JOIN LoginLog ON  tEventDelete.sessionID  = LoginLog.sessionID   
union
SELECT userAction, actionTime, LoginLog.sessionID, FormLog.username,  FormLog.IPaddress
FROM  FormLog Inner JOIN LoginLog ON  FormLog.sessionID  = LoginLog.sessionID   
Union ALL
SELECT userAction, actionTime, LoginLog.sessionID, tNewsLog.username, tNewsLog.IPaddress
FROM tNewsLog  right JOIN LoginLog ON tNewsLog.sessionID  = LoginLog.sessionID
Where tNewsLog.sessionID  is null
Union
SELECT userAction, actionTime, LoginLog.sessionID, tEventDelete.username, tEventDelete.IPaddress
FROM  tEventDelete right JOIN LoginLog ON tEventDelete.sessionID  = LoginLog.sessionID
Where tEventDelete.sessionID  is null
Union
SELECT userAction, actionTime, LoginLog.sessionID, FormLog.username, FormLog.IPaddress
FROM  FormLog right JOIN LoginLog ON  FormLog.sessionID  = LoginLog.sessionID   
Where FormLog.sessionID  is null

________
Lock S.C.