insert table into another table

0

Is it possible to insert one table type into another?
Example: I have the BOOK table and inside it I want to create a column of type AUTOR (referring to the AUTHOR table itself).

    
asked by anonymous 13.06.2018 / 19:07

1 answer

1

Yes, it is possible! Here vai give you a better idea, but already advancing:

INSERT INTO tabelaA SELECT * FROM tabelaB
    
13.06.2018 / 19:09