create table staff (name text, packageid int);
create table package (id int, amount text);
SELECT * from staff, package where staff.packageid=package.id;
James Macken wrote:
>
> Can someone demonstrate for me how to set up a simple relational database
> using the psql interactive prompt and two tables.
>
> For example: table 1 can be staff member and table 2 can be salary package
> with a one-to-many relationship (there would be a foreign key in table Staff
> Member which determined what salary package a staff member had.
>
> Can someone show me the commands to create the two tables, establish the
> relationship between them and query the two tables so that it lists the
> staff member and his/her wages (using the relationship)?
>
> It seems hard to find examples anywhere.
>
> James
>
> ************