Combine Two Tables into one With SQL

Sometimes Need Create 1 table with another 2 table column name ..

23

Arun Kr.
31-Aug-24

 

CREATE TABLE NewtableName as
SELECT colum_list(Ex- table1.student_name, table2.profile_image) FROM table1 JOIN table2 ON table1.id = table2.id

in above sql Syntax  can create a new one table with combine 2 table columns .

@Since 2024 Arun'Log Powered by Arun Git