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.