Query Null Values

  • Thread starter Thread starter marcosruapuga
  • Start date Start date
M

marcosruapuga

Hello,

how can i do to perform a query in acces with null values.

I have a table with the following:

People
----------------
NamePeople
Zone

Zones
----------------
IdZone
Zone

Select * from People Left Join Zones On Pepople.Zone = Zones.IdZone AND
Zone=[Zone]

Some people hace not zones, how can I select it.


Thanks.
 
if you just want to select all the records from the People table, where the
Zone field is Null, then try

SELECT * FROM People WHERE Zone Is Null;

hth
 
You could be wanting to use a LEFT JOIN instead of the INNER JOIN that is
offered. In my case that was the solution I found today. See message "Show
null in Select Query."
Bob - a novice ;-)

tina said:
if you just want to select all the records from the People table, where
the
Zone field is Null, then try

SELECT * FROM People WHERE Zone Is Null;

hth


Hello,

how can i do to perform a query in acces with null values.

I have a table with the following:

People
----------------
NamePeople
Zone

Zones
----------------
IdZone
Zone

Select * from People Left Join Zones On Pepople.Zone = Zones.IdZone AND
Zone=[Zone]

Some people hace not zones, how can I select it.


Thanks.
Click to expand...
Click to expand...
 
Back
Top