[fw-general] Join on different database

2013-01-10 Thread natix
Hi, I have 3 databases on the same server with the same login credentials for each database. I am trying to write a query in zf2 that selects from database A but joins in a table from database B. This query works perfectly if I execute it from the command line but I can't get it into zf2. The

Re: [fw-general] Join on different database

2013-01-10 Thread Ralph Schindler
You would need to use the TableIdentifier as your $table where $table is accepted: https://github.com/zendframework/zf2/blob/master/library/Zend/Db/Sql/TableIdentifier.php This is supported in Zend\Db\Sql\Select, Insert, Update, Delete. -ralph On 1/10/13 3:52 AM, natix wrote: Hi, I have 3