for each

[caradri]

Hi all.

I need help with a query.

I need the whole last entry from table A for each item on table B.

Thanks for any help.

[justsomeguy]

You need to use a join, you can specify the conditions when you join the tables.

[caradri]

You need to use a join, you can specify the conditions when you join the tables.

Thanks for reply.

I have this

SELECT Manager.MasterID, Manager.TakeOutUserID, Manager.TakeOutDate, Manager.TakeOutComment, Manager.ReturnUserID, Manager.ReturnDate,

Manager.ReturnComment, Manager.Status, Masters.PartNumber, Masters.Comment, Masters.Revision, Masters.Location, Masters.LastUse

FROM (Manager INNER JOIN

Masters ON Masters.SerialNumber = Manager.MasterID)

but I don't know how to select the last(newest) entry on Manager for each Master table entry.

[justsomeguy]

You can use MAX to get the largest value of a column in a table, so you'll need a column that increments with each record, or a date/time value that corresponds with entry date.