Hi Friends,
I am using a hashfile as a lookup in my server job, as a default it will be outer join . Is there any chance that I can make this as Inner Join.
If yes can anyone help me please.
Thanks
Hash File (Inner Join)
Moderators: chulett, rschirm, roy
Re: Hash File (Inner Join)
in constraint put "equal to" condition...........i mean
WHERE table_1.column_name = table_2.column_name...........taking database concept into consideration...........
WHERE table_1.column_name = table_2.column_name...........taking database concept into consideration...........
Inner Join.
Sorry Chulett,chulett wrote:Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'. ...
I didnt understand ur concept.
Could you please enlarge in detail.
thanks
karthik
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: Inner Join.
chulett is asking you to do,karry450 wrote:Sorry Chulett,chulett wrote:Just check to see if the lookup succeeded and constrain the job to only pass rows where that is true. Use the Link Variable NOTFOUND, and Not() it to check for 'found'. ...
I didnt understand ur concept.
Code: Select all
NOT(<linkname from Hashfile>.NOTFOUND)
Thanks.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted