full-outerjoin using

smohd1338 · Post by **smohd1338** » Tue Mar 12, 2013 12:19 pm

main_program: Fatal Error: Destination "leftRec.leftRec_EmployeeReconId" is already bound.

does anybody have any idea what does this mean?

I am using this as key in full outer join

prasson_ibm · Post by **prasson_ibm** » Tue Mar 12, 2013 12:22 pm

Hi,
What is the datatype and nullability of this column?

smohd1338 · Post by **smohd1338** » Tue Mar 12, 2013 12:46 pm

Hi,

its is notnull and varchar.

To give little history wt ia m doing, i have this two bills i am comapring , Prior Vs current,

In would be nending to go aand get the employeereconid added in current bill, dropped from prior bill. i ahve joined the two sqls on employee reconid and in trnasormer based on constaraints iam separating added and terminated, for the rest "emprecids" on both bills, i ll have to now cehck for their "certs" additions and termonations, so again ia m doing fullouter, with emprecid(Previously done) and certs? so doing fullouter twice on same field matter?

prasson_ibm · Post by **prasson_ibm** » Tue Mar 12, 2013 1:44 pm

Hi,
I didnt get your explanation clearly but i dont think full outer join on same filed matters.

Just search your error in this forum,you will get multiple result.For your reference i am giving you below link:-

viewtopic.php?t=127756&highlight=already+bound

smohd1338 · Post by **smohd1338** » Tue Mar 12, 2013 1:52 pm

thanks