E_FAIL when outer-joining
Dirk,
I believe that SQL 6.5 supports outer joins using the following syntax.
SELECT Test.TestID, Test.Naam, TestAdres.Adres
FROM Test, TestAdres Where Test.AdresID += TestAdres.TestAdresID
The + and which side of the = it's on is the key. I would check the SQL docs
for details. You might want to try this syntax to see if the LEFT OUTER JOIN
syntax is causing the problem. Hope this helps.
Oscar Bowyer
Quote:
>"The data provider or other service returned an E_FAIL status"
>is the message I get when I designed the following query in a VB6 data
>environment
>and tried to run it within the designer:
>SELECT Test.TestID, Test.Naam, TestAdres.Adres
>FROM Test LEFT OUTER JOIN
> TestAdres ON Test.AdresID = TestAdres.TestAdresID
>When I make it an inner join : no problem.
>But the problem is not the outer join. The problem arises only when
>there exists records
>where the Test.AdresID is null.
>For example I want all clients, also the clients without an address,
>the reason why I use
>outer joins.
>I wonder why there are problems with that.
>My underlying table is in an SQL Server 6.5 database.
>Dirk Dhaenens
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
