Alternative for LEFT OUTER JOIN

20 pts.
Tags:
LEFT JOIN
LEFT OUTER JOIN statement
SQL Left Outer Join
SQL statements
HI all, 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

<pre> <li><ol>
<ul></ul></ol></li></pre>

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Can you share with us, why you cannot use an outer join ? What database are you using ? Do you want to do this with SQL only ( or you can use a t-sql or pl/sql procedure/function) ?
    68,470 pointsBadges:
    report
  • 4knowledgexchng
    Hi.. Am using Hibernate on Postgres So I am using HQL query and in HQL to use a left outer join the two entities must be assosiated.. And I cannot assosiate those two entities at this point cos it may tweak the existing data. So i wanted an immidiate alternative for left outer join.. And i got it.. select code.batchno, (select detailA.batchfee from Detail detailA where detailA.id= code.id),( select detailB.batchfee from Detail detailB where detailB.id= code.id) from Code code where code.category = categoryA order by code.id Thank you..
    20 pointsBadges:
    report
  • carlosdl
    Thanks for sharing.
    68,470 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following