1
  • Alternative for LEFT OUTER JOIN

    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...

    4knowledgexchng20 pointsBadges:
  • After trigger select from other tables using joins

    Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E.... even if those records had no action applied to them. I tried declaring variables from the other...

    Pmnc81795 pointsBadges:
  • Left outer join

    I have 5 related tables. The main table is meeting. The other tables are participant_meeting, vendor,user_id, address. I need the meeting information and the particpant who attentds the meeting(participant_meeting), and their address(address) the vendor for the meeting (vendors) , user_id for the...

    Niveanand5 pointsBadges:
  • Joining Tables in SQL Server

    What is the difference between Outerjoin and Left outerjoin.

    Bijaybehera2915 pointsBadges:
  • left outer join in trigger DB2 Z/OS

    I'm having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT ,...

    X000055 pointsBadges:
1

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.

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

Following