Hi All,

I am trying to create a view with the following code:

SELECT Revdata.revcode, Revdata.hcfa_cc, Revdata.dutnum, Revdata.cnttot,;

Hret98.flag93;

FROM hret!revdata INNER JOIN hret!hret98;

INNER JOIN hret!revdata;

INNER JOIN hret!revdata;

INNER JOIN hret!revdata ;

ON Revdata.disdat =3D Hret98.disdat ;

ON Revdata.mrecno =3D Hret98.mrecno ;

ON Revdata.hospnm =3D Hret98.hospnm ;

ON Revdata.ptctln =3D Hret98.ptctln;

WHERE Revdata.hcfa_cc <> "TOT";

ORDER BY Revdata.revcode, Hret98.flag93

This code is from the View Wizard, I am not very good with SQL yet so I =

still use the wizard a lot. I get a message data type mismatch. Can =

someone tell me where?

The view is supposed to take two file and pull all from the first file =

except if HCFA_CC =3D "TOT" and one field from the second file if the =

HospNm, Ptctln, MRecNo and DisDat are the same in the two files. The =

first file can contain multiple occurrences but the second file should =

only contain one occurrence.

TIA

Nicole