UNION and FULL outer join
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
UNION and FULL outer join
I want to confirm from you guys , Is it possible to do full outer joins and UNIONS in DS without any problem? And I think the only way to do is to use User defined SQL right??
Re: UNION and FULL outer join
Yes. I have done that in User Defined SQL with out any problem.DeepakCorning wrote:I want to confirm from you guys , Is it possible to do full outer joins and UNIONS in DS without any problem? And I think the only way to do is to use User defined SQL right??
Raj
You can achieve the same effect with a series of hash files and passes thru the data. But it would not be the elegant solution. If a UNION is what you desire, that is a database action best suited to be done in a database. a UNION ALL can be achieved by simply concatenating like structured text files together. A full outer join can be achieved thru a similar concatenation of like structured files followed by a merging operation using something like the Aggregator stage to group by a the merging key fields and MAX(xxx) operating the remaining fields.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 2
- Joined: Tue Sep 13, 2005 11:15 pm
Last edited by hari_pulakanam on Tue Sep 20, 2005 4:59 am, edited 4 times in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: