Loading
Insert Data using joins.
  • Joginder Banger

    Joginder BangerPosted Feb 13, 2020, 11:12 PM

    1. INSERT INTO Table1 (Field1, Field2)  
    2. SELECT a.Field1, b.Field2  
    3. FROM TableA a   
    4. INNER JOIN TableB b ON a.ID = b.ID  
    try this way
  • Rajanikant Hawaldar

    Rajanikant HawaldarPosted Feb 13, 2020, 11:18 AM

    Correct me if I understand wrong https://www.w3resource.com/mysql/inserting-updating-deleting/insert-with-left-join.php https://stackoverflow.com/questions/20404682/sql-insert-into-from-multiple-tables/20404789 https://stackoverflow.com/questions/52382378/insert-statement-with-a-join-between-two-tables https://dba.stackexchange.com/questions/71852/how-to-insert-values-into-a-table-from-two-different-tables