 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Terry
Guest
|
 Posted: Thu Feb 17, 2005 9:46 pm Post subject: syntax error in from clause |
 |
|
using ADO, D6, microsoft access 2000 data base.
get syntax error in from clause for
select c.cntr_name, c.cntr_fedid, p.pyt_fedid, p.pyt_depositdate,
p.pyt_payrolldate,
p.pyt_unionid
from contractor c
join payments p on (c.cntr_fedid = p.pyt_fedid)
payments tables is a child table for contractor (one contractor to many
payments)
|
|
| Back to top |
|
 |
Andy
Guest
|
| Posted: Thu Feb 17, 2005 11:19 pm Post subject: Re: syntax error in from clause |
|
|
try changing the Join type eg
select c.cntr_name, c.cntr_fedid, p.pyt_fedid, p.pyt_depositdate,
p.pyt_payrolldate,
p.pyt_unionid
from contractor c
inner join payments p on (c.cntr_fedid = p.pyt_fedid)
Andy
"Terry" <cooleyt (AT) woh (DOT) rr.com> wrote
| Quote: | using ADO, D6, microsoft access 2000 data base.
get syntax error in from clause for
select c.cntr_name, c.cntr_fedid, p.pyt_fedid, p.pyt_depositdate,
p.pyt_payrolldate,
p.pyt_unionid
from contractor c
join payments p on (c.cntr_fedid = p.pyt_fedid)
payments tables is a child table for contractor (one contractor to many
payments)
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
