-
T-sql help syntax joining 3 tables
i have three tables a, b, c.
I want to have an inner join with tables (a and b) with an outer join with table c.
What is the simplest and easiest method to create this. Can I create a temporary inline view tables a and b then join with table c in sql server 05?
Hope to hear from anyone.
Regards,
Nijojo.
-
You can use parentheses to define the order in which you want them joined, you don't need to create inline views.
-
Agreed ... and this is a better practice ...
Using the parentheses approach is a cleaner path to follow when you return later (or someone else does so) and is attempting to understand your intent, from a design perspective...
Good luck.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|