Re: SQL syntax

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ralph wrote:
I was able to get it to work late last night with:
"WHERE 'tblOpenEvents.Bit_No' = ' Bit ' AND ' tblOpenEvents.Bank_No ' =
' Bank ' "

Thanks for your time.
I wish I could find detailed info on SQL syntax and standards, I've
struggled with these forever.



Google using the search string "sql reference tutorial" and take your pick.

You will need a good book. Actually you will likely end up with at least
three - one a good generally introductionary guide to "Learning SQL", a
"Reference Manual", and then one specifically for the RDBMS you are using.

What is seldom appreciated by programmers when they first encounter SQL is
that it is a "programming language" in itself - declarative not procedural -
but a language none the less. It has clauses (blocks) and conditionals to
produce a result. Just like any programming language it takes time to learn.
Save yourself endless grief and take some time to learn it.

-ralph


I agree with Ralph totally on that.

Your above "WHERE..." .
That would work without producing an error, but do you get any records returned?

Graham
.

Relevant Pages

  • Re: SQL syntax
    ... I wish I could find detailed info on SQL syntax and standards, ... Google using the search string "sql reference tutorial" and take your ... Just like any programming language it takes time to ...
    (microsoft.public.vb.database)
  • Re: SQL syntax
    ... I wish I could find detailed info on SQL syntax and standards, ... Google using the search string "sql reference tutorial" and take your ... Just like any programming language it takes time to ...
    (microsoft.public.vb.database)
  • Re: SQL syntax
    ... I wish I could find detailed info on SQL syntax and standards, ... Google using the search string "sql reference tutorial" and take your ... Just like any programming language it takes time to ...
    (microsoft.public.vb.database)
  • Re: SQL syntax
    ... I wish I could find detailed info on SQL syntax and standards, ... Google using the search string "sql reference tutorial" and take your ... Just like any programming language it takes time to ...
    (microsoft.public.vb.database)
  • Re: Abfrage meherer MWSt.-Sätze
    ... Ralph Rutschmann schrieb ... ... Zitat aus dem Helpfile: "Visual FoxPro supports ... > Structured Query Language (SQL) commands and functions." ... Next by Date: ...
    (microsoft.public.de.sqlserver)