Re: joining tables in postgres
| From: | Miles Thompson | Date: | Thu, 29 Sep 2005 22:51:10 +0000 |
| Subject: | Re: joining tables in postgres | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40423@lists.php.net to get a copy of this message | ||
At 04:13 PM 9/29/2005, redhat wrote:
anyone know of any good tutorials on simple joining of tables in Postgres using PHP? I did some Googling and didn't find anything satisfactory. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpYou mean like this, after establishing the connection ... $sql = "SELECT childname, childinitial, surname FROM children, parent WHERE children.familykey = parent.familykey"; $result = pg_query( $sql); and then process the results using the appropriate pg_ commands. See the manual. But the join is done with the SQL. Regards - Miles