Hi All
I have a few questions and I am hoping some of you gurus maybe able to help.
As I understand, there are 3 basic types (and some subtypes) of joins: inner
join, outer join and cross join. What is the difference between the cross
join and fuller outer join and why would you ever use self join?
Apart from prepared and direct execution, is there any other types?
And finally, what do these settings mean:
rdExecDirect
SQLExecDirect
rdPrepare?
Thanks,
George
I have a few questions and I am hoping some of you gurus maybe able to help.
As I understand, there are 3 basic types (and some subtypes) of joins: inner
join, outer join and cross join. What is the difference between the cross
join and fuller outer join and why would you ever use self join?
Apart from prepared and direct execution, is there any other types?
And finally, what do these settings mean:
rdExecDirect
SQLExecDirect
rdPrepare?
Thanks,
George