multiple database join with pdo

multiple database join with pdo

am 28.11.2006 21:10:41 von Tate

is it possible to join two tables from two different databases using pdo?
thanks,
tate

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: multiple database join with pdo

am 28.11.2006 23:05:04 von Bastien Koert

have you tried the standard sql method

select database_name1.table_name1.field_nameA,
database_name2.table_name2.field_nameB from
....


Bastien

>From: "C. Tate Baumrucker"
>To: php-db@lists.php.net
>Subject: [PHP-DB] multiple database join with pdo
>Date: Tue, 28 Nov 2006 15:10:41 -0500
>
>is it possible to join two tables from two different databases using pdo?
>thanks,
>tate
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

____________________________________________________________ _____
Experience Live Search from your PC or mobile device today.
http://www.live.com/?mkt=en-ca

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: multiple database join with pdo

am 28.11.2006 23:41:13 von Chris

C. Tate Baumrucker wrote:
> is it possible to join two tables from two different databases using pdo?
> thanks,

Depends if the underlying database supports it. Postgres doesn't without
using an external program, no idea about mysql.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php