On Thu, 2005-03-03 at 18:00 -0500, Hrishikesh Deshmukh wrote: > Hi, > I want to do a 17 table join! :( But a general idea will help. > > Thanks, > H Try here to start: http://www.postgresql.org/docs/current/static/tutorial-join.html > SELECT * > FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name); Cheers, Robby -- /*************************************** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | robby@xxxxxxxxxxxxxxx * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting & Development * --- Now hosting Ruby on Rails Apps --- ****************************************/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
