incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119975] Query Designer adds table name twice
Date Wed, 13 Jun 2012 07:26:54 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119975

r4zoli <r4zoli@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |r4zoli@apache.org
         Resolution|---                         |INVALID

--- Comment #1 from r4zoli <r4zoli@apache.org> ---
The AS keyword is optional in table alias by SQL standard definition.

You can find good SQL tutorials over the internet:
http://my.safaribooksonline.com/book/databases/sql/0321334175/joins/ch07lev1sec2

"table [AS] alias


table is a table name, and alias is its alias name. alias is a single, unquoted
word that contains only letters, digits, or underscores; don't use spaces,
punctuation, or special characters. The AS keyword is optional."

-- 
You are receiving this mail because:
You are on the CC list for the bug.

Mime
View raw message