I am new to databases.
I have table 1, a primary source, which generates a serial number to make each item unique.
I want to use this number to generate a row in table 2 linking the two rows and allowing specific information on each item to be developed..
I have a number of books, including one specifically for Postgres.
What I don't have is the language to look this function up.
Concepts like JOIN appear to used to create views not new rows on other tables.
Help will be appreciated.
Bob Pawley