join

[learn]

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

[marist89]

yes, yes.

[learn]

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

[amar]

yes.

-amar