merging 2 rows into 1 row
Hi ,
i have 2 tables
table a
m_id name
1 abcd
2 bcde
table b
m_id id org_name ind_name
1 1192 gold coast
1 1193 fred
2 1196 greg
2 1198 TechTronics
i am now generating the report through a sql query whose output shud be
id Id Org_name Ind_name
1 1192 or 1193 gold_coast fred
2 1196 or 1198 TechTronics greg
How to achieve this?
i tried self join but that is giving me the message no more spool space(the original table is bigger about 2 million records)?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 17, 2008 5:48 PM
UPDATED:
December 17, 2008 6:04 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
