471,122 Members | 1,167 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

Joins, Execution And Stuff

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
Jul 17 '05 #1
0 1276

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Prem | last post: by
9 posts views Thread by Ed_No_Spam_Please_Weber | last post: by
2 posts views Thread by Justin Powell | last post: by
9 posts views Thread by shapper | last post: by
36 posts views Thread by TC | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.