I want to make sure I understand the difference between queries and manipulation:
When I use the SELECT command, I am only changing how the tables look temporarily, to run an analysis or get some kind of results. But, I’m not actually changing or manipulating the tables.
When I use the commands JOIN or UNION… those are also only temporary ways to view tables in a combined fashion, correct?
So: how do I convert these SELECT commands and update the tables I’m working on? If I understand correctly, this would be with the CREATE TABLE, INSERT, ALTER TABLE, DELETE and UPDATE commands. So: if I use these, than I’m manipulating and changing the actual tables. Is this correct?