Welcome Guest, Not a member yet? Register   Sign In
Codeigniter querying multiple databases in same query
#1

[eluser]behnampmdg3[/eluser]
Hi;

I know I can use multiple databasaes. But in this situation I have multiple databases IN THE SAME QUERY.
Code:
SELECT *
FROM   portal.orders
       INNER JOIN portal.orderproducts
               ON portal.orders.id = portal.orderproducts.order_id
       INNER JOIN h2g.packages_daily_deal
            ON
                   ( portal.orderproducts.product_id = h2g.packages_daily_deal.crm_id
                   OR
                   portal.orderproducts.product_id = h2g.packages_daily_deal.crm_id_thd
                   )  
       INNER JOIN portal.customers
               ON portal.orders.customer_id = portal.customers.id
WHERE
       ( portal.orders.brand = '432' OR portal.orders.brand = '123' )
    AND portal.orders.reported_to_mwa <> 1
       AND portal.orders.status_id = 5
       GROUP BY portal.orders.id
       ORDER BY email
How can I do that?


Messages In This Thread
Codeigniter querying multiple databases in same query - by El Forum - 10-24-2013, 07:29 PM
Codeigniter querying multiple databases in same query - by El Forum - 10-25-2013, 02:51 AM
Codeigniter querying multiple databases in same query - by El Forum - 10-31-2013, 09:17 PM
Codeigniter querying multiple databases in same query - by El Forum - 11-01-2013, 11:40 AM



Theme © iAndrew 2016 - Forum software by © MyBB