Re: ANSI 97 SQL (MS ACCESS)


"Rick" <Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1711CCDA-8562-4E2E-A5C0-B6CBEA86A676@xxxxxxxxxxxxxxxx

> I'm working on a VB 6.0 application that uses DAO 3.51 to connect to an MS
> Access 97 database (I know it's quite old, please save your comments)
>
> My problem is in Access's SQL syntax. The program is suppossed to
> automatically bluid the queries (they are all SELECT statements). I find
> that
> the INNER JOIN statements are quite different from SQL2000.
>
> Is there any information on Internet that teaches me how to build queries
> from access97? The problem is with the INNER JOINs, since I have to relate
> several tables at once.

Access formats its joins in a funky manner (lots of parentheses and
nesting), but it's not necessary and they can generally be rewritten in a
straightforward manner. Simply put, if you're familiar with SQL, write the
statement manually and plop it into an Access query. It should work. If not,
post the SQL here and we'll try to help.


.

Relevant Pages

  • Re: 2 crosstabs
    ... I have no problem using one query as the source for a line graph. ... problems comes when I want to combine both queries into one line graph. ... sense of it to generate my own SQL: ... Orders INNER JOIN (Products INNER JOIN [Order ...
    (microsoft.public.access.queries)
  • Re: ANSI 97 SQL (MS ACCESS)
    ... > My problem is in Access's SQL syntax. ... > automatically bluid the queries. ... > the INNER JOIN statements are quite different from SQL2000. ... SQL joins are SQL joins. ...
    (microsoft.public.vb.general.discussion)
  • Re: Relational question
    ... the two queries are equivalent but with further explanation ... requiring its use in an equivalent SQL query. ... >Note that if this were an INNER JOIN we would only need to ... >>otherwise the two original joins do not even have the same sets of ...
    (microsoft.public.sqlserver.programming)
  • Re: DB structure question
    ... would run without flaw in SQL Server. ... > and use the Access Query Builder to create my query using the GUI Design ... > FROM (Reviews As A INNER JOIN Book_users As B ... > All queries should be designed, created and tested using the Access Query ...
    (microsoft.public.inetserver.asp.db)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
Loading