Tuco Benedicto Pacífico Juan María Ramírez (en_ki) wrote,
Tuco Benedicto Pacífico Juan María Ramírez
en_ki

Sure you can.

beancounter=# select date, AAPL.day_open as "AAPL", "OJH08.NYB".day_open as "OJH08.NYB"
from (select date, day_open from stockprices where symbol = 'AAPL') as AAPL
join (select date, day_open from stockprices where symbol = 'OJH08.NYB') as "OJH08.NYB"
using (date);
    date    |  AAPL  | OJH08.NYB 
------------+--------+-----------
 2008-03-10 | 121.98 |     124.5
(1 row)

(Oranges win.)
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 2 comments