Apologies, I updated the code to the below but now have a new error - "The specified field 'Processing_Month' could refer to more than one table listed in the FROM clause"
I'm confused as I thought the whole point of referring to the tables in the SELECT clause was to tell it specifically which table I want the field taken from?
Code:
SELECT [received_flight_files_table].Processing_Month AS ProcessingMonth, [received_flight_files_table].IATA_Code AS IATACode, [received_flight_files_table].Airline AS Airline, [received_flight_files_table].Received_Date AS ReceivedDate, [uploaded_flight_files_table].Uploaded_Date AS UploadedDate, [published_flight_table].Published_Date AS PublishedDate
FROM received_flight_files_table, uploaded_flight_files_table, published_flight_table
WHERE Format ([received_flight_files_table] (Processing_Month, "mmyy")) = [enter MMMYY];
My end goal really is just to have the following in one query;
- Processing_Month taken from the received_flight_files_table
- IATA_Code taken from the received_flight_files_table
- Airline taken from the received_flight_files_table
- Received_Date taken from the received_flight_files_table
- Uploaded_Date taken from the uploaded_flight_files_table
- Published_Date taken from the published_flight_table