visit : https://zonixsoft.com (our official website)  INSERT offers the ability to insert into a table based upon a SELECT statement with the following syntax: INSERT INTO [TABLEA] ([FIELDA],[FIELDB],[FIELDC])         SELECT [FIELDA],[FIELDB],[FIELDC] FROM [TABLEB]   there are time where you may want to do a similar approach with UPDATE. Here is the syntax to do that […]