A logical doubt

[arnie_nits]

Hi,

I have a small doubt.

If we do an inner join on the basis of dummy column then the records get duplicate as it will do a cartesian product.

Is it same in the case of left outer join.......can we get duplicacies???

Regards
Arnie.

[ray.wurlod]

That's up to you and your data - it's nothing to do with the join itself. If there are duplicates on the left input to a left outer join then, yes, you can get duplicates on the output. It's all in the definition of a join.