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).
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).
Yes, it is possible! Here vai give you a better idea, but already advancing:
INSERT INTO tabelaA SELECT * FROM tabelaB