SQL Statements/Syntax

[Anthony]

Will someone be so kind and point me in the direction I need to go to find
information about SQL Statements and Sytax?

Thank you,
Anthony

 

[fredg]

Will someone be so kind and point me in the direction I need to go to find
information about SQL Statements and Sytax?

Thank you,
Anthony

Note.... It is not necessary to post to so many newsgroups. If you
feel you absolutely must post to more than one group, two or three
should be all that is needed.

For Access?
Did you look in Access Help?
Help + Contents + Microsoft Access Help + Microsoft Jet SQL Reference

Did you perform a search on the Internet for "SQL"?
The first of 18,500 hits on my search engine returned:

SQL Tutorial
Well organized easy to understand SQL tutorial with lots of examples.
Including PHP, ASP, ADO, Oracle, Access, SQL Server. Related: HTML,
JavaScript, XML, ...
http://www.w3schools.com/sql/default.asp - 23k - Cached -
Similar pages

Good luck.

 

[strive4peace]

Hi Anthony,

to help you understand a bit better, send me an email and request my
30-page Word document on Access Basics (for Programming) -- it doesn't
cover VBA, but prepares you for it because it covers essentials in
Access. There is a section on SQL statements.

For VBA Syntax, I send out the first 3 chapters of a book I am writing
on VBA to all who request it... basic syntax is covered in chapter 3.

Be sure to put "Access Basics" and/or "VBA manual" in the subject line
so that I see your message...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

Hi Anthony,

to help you understand a bit better, send me an email and request my
30-page Word document on Access Basics (for Programming) -- it doesn't
cover VBA, but prepares you for it because it covers essentials in
Access. There is a section on SQL statements.

For VBA Syntax, I send out the first 3 chapters of a book I am writing
on VBA to all who request it... basic syntax is covered in chapter 3.

Be sure to put "Access Basics" and/or "VBA manual" in the subject line
so that I see your message...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Jamie Collins]

Will someone be so kind and point me in the direction I need to go to find
information about SQL Statements and Sytax?

Standard SQL basics:
http://www.sqlcourse.com/

Jet 4.0 SQL DML:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

Jet 4.0 SQL DDL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

Jet 4.0 SQL DCL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

Jamie.

--