My First Join In Postgresql

cddb=> select a.artname, p.pubname, c.cdtitle
cddb-> from artist a, publisher p, cdtable c
cddb-> where a.artnum = c.artnum
cddb-> and p.pubnum = c.pubnum;
artname | pubname | cdtitle
----------+-----------------+-------------
Phatfish | Authentic Media | Heavenbound
(1 row)

cddb=>

Exactly the same as Oracle really!