I have two tables, Recordings (fields: RecordingID, song_id) and Songs (fields: SongID, Title, AlternateTitle). What I want is an update query that will do this (in pseudo code):
I can't figure out how to do this, but I feel like there must be a way.Code:If Recordings.song_id = Songs.SongID and Songs.AlternateTitle="DELETE" THEN update song_id to Songs.SongID where Songs.AlternateTitle="KEEP"