S
Sean
I am getting an error for this query. The error is, "Data type mismatch in
query expression" Any ideas on what's wrong?
select s.txn, s.material, min(s.rdate) as Thedate
from 101_311 as s inner join
(select temp.txn, temp.material, temp.rdate
from 101_311 as Temp
where txn = 101) as Q
on s.txn = q.txn
and s.material = q.material
and s.rdate > q.rdate
group by s.txn, s.material
query expression" Any ideas on what's wrong?
select s.txn, s.material, min(s.rdate) as Thedate
from 101_311 as s inner join
(select temp.txn, temp.material, temp.rdate
from 101_311 as Temp
where txn = 101) as Q
on s.txn = q.txn
and s.material = q.material
and s.rdate > q.rdate
group by s.txn, s.material