G
Guest
I am being driven mad by what I think should be a simple query. I have a database with one table (Work_Item), which relates to two others (A_Comments) and (B-Comments) with a 1 to many relationship. These two tables are of similar structure and both contain dates. What I want to do is produce a query which shows ALL items from the main table, and the most recent item from the both of the two other tables ie Max date, relating to each item from the main table. I can't for the life of me get this to work. I can find various bits of sample SQL to do something similar within one table, but it dosn't seem to work when there are various joins involved. CAN ANYONE HELP