About Access SQL

[johnnwicky]

Im Learning SQL Certification training , 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 new to SQL 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 

[Barand]

Try

SELECT A FROM TableA LEFT OUTER JOIN TableB
ON Table A. Column A = Table B. Column B
AND Table A. Column A = Fixed value 
WHERE Column B IS NULL  

-- or --

SELECT A FROM TableA LEFT OUTER JOIN TableB
ON Table A. Column A = Table B. Column B  
WHERE Table A. Column A = Fixed value
AND Column B IS NULL  

Record selection conditions normally go in the WHERE clause.

However, they can be in the JOIN's ON clause.

If the condition were on a column in TableB (which is LEFT JOINed) then the condition would have to be in the ON clause.