Query help needed!

[Tursas]

I have datebase where are following tables:

Products
Users (UserID)

Product table includes following columns:

ProductID
InsertDate
InsertBy (
ChangeDate
ChangeBy
ProductName
ProductDescription

How can I make a query that comes up with a following result:

ProductName Inserted By Changed By Description
=========== =========== ========== ===========
Car Peter Mark V8 engine

Please help me with this one.

Thank you!

tursas

 

[Tursas]

I got this far.........

SELECT *
FROM product, users
WHERE product.insertby=users.userid

tursas