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
|