Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update query (Max(Date))

Status
Not open for further replies.
prettitoni

prettitoni

Programmer
Apr 22, 2004
74
US
Can someone help me write an UPDATE query that sets the Date of Table1 equal to the Max(Date) in Table2 where the tables are joined on Table1.ID = Table2.ID?
 
Sort by date Sort by votes
how about:

UPDATE TableName T1 SET SomeDate = (SELECT MAX(SomeOtherDate) From Table2Name T2 WHERE T1.ID = T2.ID)

Leslie
 
Upvote 0 Downvote
If only it were that simple....that query gives an error "Operation must use an updateable query
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
853
Andrzejek
Andrzejek
C
  • Question
Query expression negative to a 0
Replies
6
Views
369
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
872
strongm
strongm
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
251
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
570
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top