Re: ODBC Access syntax for CREATE TABLE (and two questions)

On Mon, 27 Aug 2007 12:03:56 GMT, wawang@xxxxxxxxxxxxxxxxxxxx
("Walter Wang [MSFT]") wrote:

Hi Maurizio,

As far as I know, Access supports LEFT OUTER JOIN, though it has some
issues if you're not using latest JET 4.0 service pack:

#You receive incorrect results from an Outer Join query
http://support.microsoft.com/kb/275058

[some snipped...]

Although Access might support this syntax, does the ODBC driver
support it?

--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.

Relevant Pages

  • RE: asp not retrieving correct information from a query
    ... dbo.DISTRIBUIDORES DISTRIBUIDORES1 RIGHT OUTER JOIN ... dbo.CAT_STATUS_SOLICITUD INNER JOIN ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.inetserver.asp.db)
  • Re: How Jet Engine Optimizes between linked (remote?) tables?
    ... Access/Jet does not support UNION JOIN. ... its LEFT/RIGHT OUTER JOIN syntax is not ... While Access/Jet doesn't explicitly support the in-line CROSS JOIN ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Full Outer Join?
    ... supported FOJ while continuing to offer ... Is there a standard on _how_ the database is supposed to support the ... One cannot check against the nullability of the outer join restrictions ...
    (comp.databases.sybase)
  • Re: Full Outer Join?
    ... Is Full Outer Join is supported by Sybase ASE 12.x? ... Nope -- yet another feature that Sybase does not support directly. ... (which are supported by most other database servers) ...
    (comp.databases.sybase)
  • Full Outer Join?
    ... what is the symbol equivalent to FULL OUTER JOIN? ... I tryed *=* but SQLServer doesn't support it. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)