
September 14th, 2003, 03:20 PM
|
|
Registered User
|
|
Join Date: Sep 2003
Posts: 4
Time spent in forums: 2 m 28 sec
Reputation Power: 0
|
|
|
whats wrong with my query
This is a query created in access:
SELECT Duiven.Rin, Vader.Rin, Moeder.Rin, VaderVader.Rin, MoederVader.Rin, VaderMoeder.Rin, MoederMoeder.Rin
FROM (((((Duiven LEFT JOIN Duiven AS Vader ON Duiven.Vad=Vader.Rin) LEFT JOIN Duiven AS Moeder ON Duiven.Moe=Moeder.Rin) LEFT JOIN Duiven AS VaderVader ON Vader.Vad=VaderVader.Rin) LEFT JOIN Duiven AS MoederVader ON Vader.Moe=MoederVader.Rin) LEFT JOIN Duiven AS VaderMoeder ON Moeder.Vad=VaderMoeder.Rin) LEFT JOIN Duiven AS MoederMoeder ON Moeder.Moe=MoederMoeder.Rin
WHERE (((Duiven.Rin)="2326169"));
Now when i copy paste this into the custom query field from the frontpage DRW
it gives me a blank page
Anyone knows the reason for this? beceause in access the query works just fine
|