Hands-on task
This task is step 5 of the course “PostgreSQL: from your first database to transactions”
PostgreSQL: INNER JOIN
In the shop database there are tables customers(id,name,city) and orders(id,customer_id,amount). For each order, output the pair name|amount, sorted by amount ascending, into /root/join.txt (psql -tA format, fields separated by |).
Reference:psql
What you'll practise:
- join
- inner join
- foreign key
- postgresql
- psql