We have views that reference more than one table. Our views have a primary table they are based upon and fields from "non-primary tables." To make it very clear which fields are which, there's been a bit of discussion regarding how to make it visually distinct that a particular field is from a table that is not the primary table of the view. Which of the following is clearer?
Using double underscores to separate the other table name from its field name:
Quoting column names and using periods as separators:
Is the latter portable? Is the former too confusing? Which is easier to read? Are there reasonable alternatives?