Insert Into Table From Another Table Examples

To Insert into table from another table we use insert statement with select statement. 

Important Notes

To insert data a table from anathor table we must use insert statement with select statement.

At hhis queries, we don’t use values statement.

Insert into statement’s column count and select statement’s column count must be the same

Data types must be same at same order

The Syntax must be like below

Query Examples

TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK

Example 1: Insert into the authors table, Random selected five students

Example 2: Add the authors whose name contains “a” character from autors table to students table. The class of autors will have been ’12M’

Example 3: Add students to the authors table whose class 11A

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: