Hello guys ,
I kinda need your help , i spend some time on this query and i don't really see how to do that ( tried join ad add column )
Here is an example of my table :
Sold on Bought on Car
aug14 oct12 Ferrari
july14 sept13 Lamborghini
sept13 aug13 Porsh
nov13 oct13 Mercedes
The thing i wanna do is to show for each month ( i know how to do that ) the number of cars bought AND sold . The car doesn't mar
So basically i have to count sold on and Car for each of the months , and the same thing for car and bought .
But how to join them ?? ...
Thanks a lot !
... View more