Re: ON ... AND statement problem

Hi,

Thanks for your answer. At first, it's possible that I do not make enough
difference between the processing of ON and WHERE statement, i do not have a
long experience with SQL.

I use it Because
- examples shows that it's possible to add condition in the on statement
- it works with enough brackets.
- RCABLE_NDS.CATEGORIE cab be 1, 2, 3 and I thank it was better to join
directly with the good value in the table.
- Finally because my different tests with WHERE gave me "syntax error" and
then back to the two first point. Obviously, if I do not use properly the ON
clause I would try something else but would you be so kind to explain why,
according to those two same points ?

.

Relevant Pages

  • translate SQL to Access
    ... I'm trying to translate the below query I had in SQL for use in Access. ... getting a syntax error (missing operator) in this clause ...LIKE CASE 'C' ...
    (microsoft.public.access.queries)
  • Re: Search for a title containing two words that are not together
    ... database. ... syntax error or blank results. ... Try this SQL where clause: ...
    (microsoft.public.access.queries)
  • Inner Outer Joins etc D7-ADO-Access2000
    ... Can someone possibly help me with this, basically i'm try to do a left join with 3 tables, but i get a "Syntax error in from clause" error from Delphi. ... Here's the SQL i use: ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Better "Join" vs "Where" clause?
    ... running the SQL directly, in the SQL Server tools, rather than ... WHERE clause has been deprecated, ... AFAIK one cannot perform an outer join in Access without using the explicit ...
    (microsoft.public.access.queries)
  • RE: hope this is an easy one for somebody
    ... yeah, he suggested either those 2 sets of brackets as above, or no brackets ... Dim strSQL As String ... 'Note that you could use a condtion in the above sql ... But this is exactly the ApptID I want - why does it not like this sql? ...
    (microsoft.public.access.formscoding)
Quantcast