Getting a result from select query where a field in one table is Null

[MDelke]

I have two Tables I am selecting from
Name: tableControl.PNG  Views: 24  Size: 20.7 KB  ID: 45990" class="size_medium" />

 "SELECT QSO ID, Call
            FROM QSO - Master
            LEFT JOIN MRC - Control
            ON QSO MASTER.County ID = MRC Control.County ID
            WHERE MRC - Control.QSO ID Is NULL; ", conn)

I am using Windows 10 and Access 2016
I get Syntax error(missing operator) in query expression.

Both tables have QSO ID, they both have county ID and they are both unique. But I only want the QSO's from QSO - Master that will fill the needs of the County ID from MRC - Control
I am really new to writing other than simple SELECT statements. Any Help would be appreciated.
I have included a snip of the two tables to hopefully clearify the situation.

Thanks in advance

Mike

[ssanfu]

It looks like you have ADO syntax (the ", conn) but I really think the error is because your object naming convention is not good.
Object names should:
---------------------------------------------------------------------------
Use only letters and numbers (exception is the underscore) for object names.
Do not use spaces, punctuation or special characters in object names.
---------------------------------------------------------------------------
You have spaces and hyphens in the names.

Maybe something like:

 "SELECT QSOID, Call
  FROM QSO_Master LEFT JOIN MRC_Control ON QSO_MASTER.CountyID = MRC_Control.CountyID
  WHERE MRC_Control.QSOID Is NULL; ", conn)

BTW, "CALL" is a reserved word in Access and shouldn't be used for object names.

[MDelke]

I Understand what you are saying. The problem is I am getting the info from a program I didnt write. I am using its Database's to get the info for my program. and there are a few hundred Amatuer Radio Operators using the program already. I am writing a program as a utlity to make the other program more useful.

Mike

[Micron]

Maybe the best you'll be able to do is wrap these names in brackets in your sql: [QSO - Master] not QSO - Master and so on.
Those are some of the worst object names I've ever seen in programming!

[Minty]

Create a query on each of the tables and redefine the names to something sensible. e.g.

SELECT [QSO ID] as QSO_ID, [Call] as CallValue FROM [QSO - Master]

Then Save that query as qryQSOMasterTable or something else without any spaces or weird characters.

Then base all your queries on those queries.
This will save you a ton of pain with square brackets everywhere.

[MDelke]

Thank You to all that gave their ideas. Guess I will just wrap the misguided nameing in the other program on [] as there are only a couple of screens to do searchs for.

THANKS AGAIN
Mike