[GENERAL] Tables

[Bob Pawley]

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