Link to home
Create AccountLog in
Avatar of Rias
RiasFlag for United Kingdom of Great Britain and Northern Ireland

asked on

inner join and criteria in access

Hi,
I am trying to fire this query
SELECT CROSSTAB_DEFELE_by_Element.DefeleMEMBNO,CROSSTAB_DEFELE_by_Element.p9097x  FROM PERSONAL_DETAILS INNER JOIN CROSSTAB_DEFELE_by_Element ON PERSONAL_DETAILS.REFNO = CROSSTAB_DEFELE_by_Element.DefeleMEMBNO And CROSSTAB_DEFELE_by_Element.p9097x <> null

The highlighted part error as JOIN expression not supported
ASKER CERTIFIED SOLUTION
Avatar of Thomasian
Thomasian
Flag of Philippines image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account