Insert into data1 (name, age) values(‘Peter’, 25) Also, the columns in each SELECT statement must be in the same order. The columns must also have similar data types. ON lumn_name= lumn_name Ģ) inner join is the same as JOIN: selects all rows from both tables as long as there is a match between the columns in both tables.ģ) full outer join: returns all rows from the left table and from the right tableĤ) Union: combines the result of two or more SELECT statements.each SELECT statement within the UNION must have the same number of columns. The result is NULL in the right side when there is no match. 1) left join: returns all rows from the left table, with the matching rows in the right table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |