Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL editor: enhanced select statement template (Read 3356 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL editor: enhanced select statement template
11.09.06 at 09:57:47
 
The SQL editor of SQL*XL was enhanced to generate a select statement that includes more select statement optional clauses.
 
In Excel you can open the SQL*XL SQL dialog through the SQL*XL menu or toolbar. On this SQL dialog you can start the SQL*XL SQL editor. This editor can help you to build SQL statements.
 
On the left hand side of the dialog, the database tables and views are listed. If you right click on a view or on a table you can generate a select statement. The select statement that is generated now contains more optional clauses such as the where clause and the group by and order by clauses.  
 
As an example of a statement generated this way I have generated a statement to query the Authors table in the Access Biblio database.  
 
SELECT [Au_ID]
, [Author]
, [Year Born]
FROM [Authors]
WHERE <condition>
GROUP BY <expression>
HAVING <condition>
ORDER BY <expression>;
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1