MS Query

  • Thread starter Thread starter Dkso
  • Start date Start date
D

Dkso

Does anyone know where an SQL beginner can get basic help with commands in MS Query.
I have limited knowledge of SQL and want to be able to create my own Queries in MS Query but as usual the help isn't.

Web pages, news Forums etc....

I'm also after a job if anyone wants to know!

Regards Dean
(e-mail address removed)
http://homepage.ntlworld.com/dkso
 
Hi

Does anyone know where an SQL beginner can get basic help with commands in MS Query.
I have limited knowledge of SQL and want to be able to create my own
Click to expand...
Queries in MS Query but as usual the help isn't.
Web pages, news Forums etc....
Click to expand...


The syntax depends of SQL-driver you are using. When you use p.e. SQL-driver
for VisualFox, the FoxPro SQL syntax is used, and you can use a lot of
functions from FoxPro also (not all of them, but most). With SQL-driver for
Excel files you use Excel SQL syntax, so you p.e. can't use fields in WHERE
clause, which aren't present in output. And you are allowed to use only 4
functions. And so on - as rule you can nowhere in VBA-help find the
information about syntax for particular driver, you have to check by driver
provider, or when you are familar with database from where you wnt to get
the data, then you can found experimentally out which functions are
available for ODBC.


Arvi Laanemets
 
Back
Top