i have 2 tables
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)?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!