problem with outer join
From: KOUASSI Yao-Koffi (anonymous_at_discussions.microsoft.com)
Date: 04/22/04
- Next message: Mehran: "isnumber"
- Previous message: Hugo Kornelis: "Re: => Trigger to split Trailer Loads"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Apr 2004 02:54:48 -0700
Hi !
I'm migrating an application from Centura SQLBase 7.5.1 to
SQL SERVER 2000. I have a problem concerning outer joins.
With SQLBase, it is possible to make outer join between a
column and a bind variable. This functionality is not
included into SQL Server 2000.
How can I solve this problem ?
- Next message: Mehran: "isnumber"
- Previous message: Hugo Kornelis: "Re: => Trigger to split Trailer Loads"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: Bring Data into SQL Server
... Does your "other" dbms have the concepts of Primary keys, OUTER JOINS? ... Allan
Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> FROM OrderHeader JOIN ScratchOrderHeader
... (microsoft.public.sqlserver.dts) - Re: Left Joins with Linked Tables
... there are indeed cases where JET is not able to handle outer joins ... rather
than allenbrowne at mvps dot org. ... > Both of the queries are just a single
table - filtered. ... > Both of the tables are linked from a SQL Server. ...
(microsoft.public.access.queries) - Re: Outer Joins auf Views die OUTER JOINS enthalten
... ausschließlich die "neue" Syntax in SQL Server zu verwenden. ... >> Hallo,
... >> Ich habe versucht auf eine view ein select zu machen der OUTER JOINS ...
>> können in einer Abfrage, die verknüpfte Tabellen enthält, nicht ... (microsoft.public.de.sqlserver) - Re: Can someone help me with multiple "Left Outer Joins"?
... > Using three "Left Outer Joins" slows the system down considerably. ...
tables have indexes on the columns you join on, I would expect the query ... could hit
multiple rows in the latter tables. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
... (comp.databases.ms-sqlserver)
