Jump to content

johnnwicky

New Members
  • Posts

    1
  • Joined

  • Last visited

johnnwicky's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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
×
×
  • 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.