"Karla" wrote ...

i get an
error message stating that something is wrong with my
join expression...

Here is the statement:

SELECT VP FROM `Data1$` INNER JOIN `Data2$` ON `Data1
$VP`=`Data2$VP`

Try:

SELECT T1.VP
FROM [Data1$] T1
INNER JOIN [Data2$] T2
ON T1.VP = T2.VP
;

Jamie.

--