SQL Query -> Insert Info In One Table
Budget: $10 – $30 CAD
I want to transfer all relevant information from:
Table1 - Quotes => Table2 - Notes.
How would I do this in PostgreSQL?
Table 1: Quotes - 1000 rows
Columns:
- quote_id
- quote_money
- comment
- created_by
- created_on
Table 2 - Notes
Columns
- note_id
- quote_id
- note_comment
- created_by
- created_on
Table1 - Quotes => Table2 - Notes.
How would I do this in PostgreSQL?
Table 1: Quotes - 1000 rows
Columns:
- quote_id
- quote_money
- comment
- created_by
- created_on
Table 2 - Notes
Columns
- note_id
- quote_id
- note_comment
- created_by
- created_on