MySQL Forums
Forum List  »  Oracle

converting join in Oracle to mysql
Posted by: satyaki roy
Date: April 04, 2007 05:13AM

Hi Folks ,

I have a join in Oracle . The code is :-


SELECT b.security_id, bond.security_id AS close_security_id, b.dated,
s.ticker, s.maturity, s.secs_long_name AS ticker_display,
bid_price AS bid_price, ask_price AS ask_price, mid_price AS price,
bid_yield AS bid_yield, ask_yield AS ask_yield, mid_yield AS yield,
b.updated_time AS last_price_update, s.dated AS issue_date,
cds.security_id_live AS parent_cds
FROM bonds_historic b, securities s, cq_bond bond, cq_vw_cds_bond_map MAP, cq_cds cds
WHERE b.dated = TRUNC (SYSDATE)
AND s.security_id = b.security_id
AND b.security_id = bond.security_id_live
AND MAP.bond_id = bond.bond_id
AND cds.cds_id = MAP.cds_id

I want to convert this join to mysql .Can anyone post the solution ?
How should I proceed in creating a join of so many tables in mysql ?

Any help would be appreciated .

Thanks and regards,

satyaki

Options: ReplyQuote


Subject
Views
Written By
Posted
converting join in Oracle to mysql
5599
April 04, 2007 05:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.