I have 2 questions as follows:
1.can you create a join using 2 views instead of tables? IS the syntax the same as table join
2.can you create a join using 2 synonyms instead of tables? IS the syntax the same as table join
Printable View
I have 2 questions as follows:
1.can you create a join using 2 views instead of tables? IS the syntax the same as table join
2.can you create a join using 2 synonyms instead of tables? IS the syntax the same as table join
yes, yes.
Thanks. I have one more question:
Can you create a join using a combination of a view and a synonym? IS the syntax the same as table join
yes.
-amar