
February 27th, 2004, 03:08 PM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
A serious problem with Access !!!
Hello!
my problem I try to migrate my java application of Database SQL server 2000 worms === è Database Access
my request in SQL Server2000 it functions very well:
select c.varcCodeContinent, c.varclibelcontinent, p.nCodePays,
p.varclibelPays, r.nCodeRegion, r.varcLibelRegion
from unintermitting C left join country p one (c.varcCodeContinent = p.varcCodeContinent)
left join area R one (p.nCodePays = r.nCodePays)
but under Access it does not function.
however the two following requests function under Access
1) - select c.varcCodeContinent, c.varclibelcontinent, p.nCodePays, p.varclibelPays
from unintermitting C left join country p one c.varcCodeContinent = p.varcCodeContinent
2) - select r.nCodeRegion, r.varcLibelRegion
from country p left join area R one p.nCodePays = r.nCodePays
is there a solution PLEASE?
|