I know that this is a stupid question, but I can't find the answer despite
looking it up in a couple of SQL references. Following is a snippet of SQL
from a sample VB program:
sSQL = "SELECT Authors.Author, Titles.Title," & _
"Titles.ISBN FROM Titles INNER JOIN " & _
"(Authors INNER JOIN [Title Author] " & _
"ON Authors.Au_ID = [Title Author].Au_ID) " & _
"ON Titles.ISBN = [Title Author].ISBN " & _
"WHERE Authors.Au_ID = " & LstrAuID & _
" ORDER BY Authors.Author, Titles.Title"
Here are my questions:
1. What does [Title Author] mean? Is this what they mean by a virtual table,
or view? If so, I can't see from the syntax how this view is being created
in the subquery. Authors and Titles are both valid tables, and it seems that
[Title Author] is being referenced without explicitly creating it...
2. Is this SQL syntax standard? Can someone give me the name of a book that
will explain this?