select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA
on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id
I want an alternative for left outer join..
I cannot use left outer join for some purpose..
So i need an alternative for it but doing the same..
Thanks in advance
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!