select 2 fields from 2 table and combining into 1 table

[hunterboy]

this is my sql

SELECT Newlog.Computer, Newlog.Date, Newlog.User, Newlog.Time, Newlog2.Time, Newlog2.Event
FROM Newlog, Newlog2
WHERE Newlog.Event=528 And Newlog2.Event=551;


i want to select newlog.time according to the newlog.event=528 and newlog2.time according to newlog2.event=551 but it displays all the results with other events.. any error with my code?

 

[maxmangion]

in your above sql statement i cannot see the Newlog.event in the select portion

 

[hunterboy]

i added in Newlog.Event but its the same...

 

[hunterboy]

i wan to get two Time rows from two tables. one row displaying the start time which is Event 528 and one row displaying the end time which is event 551.. how do i join the 2 tables?