how do i do Join two query

[rajiv07]

Hi to All

I want to join these two queries into one.


[PHP]my $cStr="select sum(cart.rate),cart.currency,trackinfo.title,count (cart.cartid) from trackinfo,cart where cart.trackid=trackinfo.trackid and cart.currency=\'INR\' group by trackinfo.title order by trackinfo.title";[/PHP]

[PHP]my $cStr1="select sum(cart.rate),cart.currency,trackinfo.title,count (cart.cartid) from trackinfo,cart where cart.trackid=trackinfo.trackid and cart.currency=\'USD\' group by trackinfo.title order by trackinfo.title";[/PHP]


Here the currency value olny differ from two quires.so i want to join these queries into one. Is any Idea please.

Thanks In advance .

[ak1dnar]

Join for what purpose?
Based on what condition you want to get your result?

For now your Where Clause:

 where 
cart.trackid=trackinfo.trackid 
and 
cart.currency='INR'
and 

Do you prefer to put the another Condition Here

[rajiv07]

Thank u ajaxrand

Let me Explain clearly

trackinfo table

+---------+---------+
 trackid |     title 
+---------+---------+
       1 |   aa   
       2 |   bb    
 

cart table

+--------+---------+----------+------+
| cartid | trackid | currency | rate |
+--------+---------+----------+------+
|      1 |       1  | INR       |  500 |
|      2 |       2  | INR       |  500 |
|      3 |       1  | INR       |  500 |
       4 |       2 |  USD     |  100 |  

My Out what i am Expecting

----------------------------------------------------
track-title | sum(cart-rate) | currency|
-----------------------------------------------------
aa           |           1000    |      INR
bb           |            500    |      INR
bb           |           100     |      USD
----------------------------------------------------

The result should group with trackinfo.tile and cart.currency;

Is Any idea please.

Thank u.

[ak1dnar]

Just Check whether this is correct or not;

select trackinfo.title as TrackTitle ,sum(cart.rate)as Rate,cart.currency from trackinfo 
Left Join cart on trackinfo.trackid=cart.trackid 
Where cart.currency = 'INR' or cart.currency = 'USD'
group by trackinfo.title,cart.Currency

[rajiv07]

It's working.Thank u for your such a brilliant Reply.Thank u so much.

[ak1dnar]

It's working.Thank u for your such a brilliant Reply.Thank u so much.

Glad to hear that. post back anytime to the Forum. Good Luck!