query with ADO

[oigo]

Hello, I get this query

select * from c, a where c.id=a.cid

in the recordsource of an adodc, i get a textbox attach(datafield and datasource propoerties are good) to this control but it doesn´t show the value of the field, i made the same query in Access and it works, when I query a table, for example c, it works, what is wrong?

thanks

 

[Malchik]

Hi

this query seem a bit wierd:
select * from c, a where c.id=a.cid

if its a join you should have something like:
select * from c inner join a on c.id=a.id
or
select * from c right join a on c.id=a.id
or
select * from c left join a on c.id=a.id

it depends of what you really need to do!
Mal'chik