elly.khanlar
Registered User.
- Local time
- Today, 02:31
- Joined
- Oct 3, 2019
- Messages
- 23
Hi everyone, I have a make a union query which I am trying to union two tables together.
In one of the tables, I don't want two things to be included in two fields in Table A that contain certain criteria.
Here is my SQL which is not working and I get this error" Undefined function "Where" in expression.
here is my
SELECT field 1, field 2, field 3, field 4
From table A
WHERE(table A.FIELD 2])<>"Syrups")
OR
WHERE((table A.field 4])<>1)
UNION ALL SELECT *
FROM [table b)
In one of the tables, I don't want two things to be included in two fields in Table A that contain certain criteria.
Here is my SQL which is not working and I get this error" Undefined function "Where" in expression.
here is my
SELECT field 1, field 2, field 3, field 4
From table A
WHERE(table A.FIELD 2])<>"Syrups")
OR
WHERE((table A.field 4])<>1)
UNION ALL SELECT *
FROM [table b)