About Access SQL question

[johnvickyy]

I would like to ask an Access SQL question.

There is a code like the following, but I would like to add a comparison with a fixed value as an or condition.
I'm Learning SQL certification and it doesn't work.

I would appreciate it if you could teach me.

SELECT A FROM TableA LEFT OUTER JOIN TableB

ON Table A. Column A = Table B. Column B

WHERE Column B IS NULL

↓

SELECT A FROM TableA LEFT OUTER JOIN TableB

ON Table A. Column A = Table B. Column B

OR Table A. Column A = Fixed value

WHERE Column B IS NULL

[PhilippK]

Hi @johnvickyy ,

review the following article as a starting point and let me know whether you could found the answer there:

https://www.alteryx.com/alteryx-sql

Best regards

Phil