I'm still quite new to SQL so pardon bad terminology.
I'm using MSAccess.
I have a pass-through query which I need to use to update a table.
This currently means a 3-query process;
- The pass-through query which gets the original data
- A 'makeTable' query that creates a temporary table from that data (in order to do the below)
- an 'Update' query that puts the data from the temporary table into the main table to be updated.
As my end project is going to be kind of complex, i'd like to combine these queries somehow or other. Does SQL support calling different queries from each other, or writing a procedure that runs through them all? I know it can be done in VBA but kind of wanted to minimise the amount of different queries in my navigation pane.
(This question is as much out of interest as for actual usefulness - any advice appreciated)
question from:https://stackoverflow.com/questions/65844440/run-multiple-sql-actions-in-a-single-procedure
