Multiple-step OLEDB operation generated errors

[Vbbeginner07]

Multiple-step OLEDB operation generated errors.Check each OLE DB status value,if available.No work was done



what i ahve to check?

And the code is
(VB)
rs.Open "select distinct empdetail.name, saldetail.id from empdetail,salde tail where saldetail.id = empdetail.id", conn, adOpenStatic, adLockOptimisti c

PLS Help,thanks in advance

[QVeen72]

Hi,

Datatype for ID field in Both tables should be same..
example: In one table, the fieldtype is Numeric and in another it must be text..

Regards
Veena