Hi All,
Mt Data is in this Format:
Table A:
Instr_id
--------
157
158
159
Table B:
Instr_id---id_ctxt_typ---iss_id
-------------------------------
157 NASDAQ 123
157 CUSIP 456
157 COMPANY 789
I need to get data in this format by using these two tables:
Instr_id NASDAQ CUSIP COMPANY
--------------------------------
157 123 456 789
158 zzz yyy xxx
How can I generate a sql which gives this type of format data.
Thanks&Regards,
Anuj