I originally asked a question about Multiple Sub Reports. I was very politely directed to this question Libre Data - multi level report, which answered my question perfectly, by providing an explanation and this sample database: InvoiceForumPost.odb.
The sample database contains a SQL
UNION command, and I have a few questions about the syntax.
Here is the result:
And here is the, annotated, command:
-I looked up the
UNION command online, and realized that I don’t need the
AS keyword in the second
-I was able to intuit from the example, that I can create a new entry in the recordset which makes the whole thing work (A).
-I’m wondering why the query works with the
AS keyword missing in the
"Materials"."ServiceDate" "Service Date" portion of the first
SELECT statement (B).
-I’m also wondering why the name of the table in the
FROM clause is repeated in each
SELECT statement (C), instead of only being entered once.
Thanks for your help.