Jump to content

About Access SQL


Recommended Posts

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 

Link to post
Share on other sites

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.