Querying with no results

[Mike]

Hi All,

I'm having an issue where I'm getting some records
incorrectly. What I have did is that I have created 3
tables user, informaiton, and favorite. I have created two
users and one of the users have all the datas entered into
all three tables. For the second user,I only entered the
datas into user and favorite tables. When I do a query for
the first users, the datas comes up as I wanted. When I do
another query for the second user,I ended up with no
result found. What I need to do to query the second user
who doesn't have the datas in the information table and
still shows up with some results, instead of no result?

Thanks for the help...

Mike

 

[John Vinson]

What I need to do to query the second user
who doesn't have the datas in the information table and
still shows up with some results, instead of no result?

Select the Join line in the query design window and choose Option 2
(or 3): "Show all records in the User table and matching records in
the Information table".

 

[Mike]

Thanks

-----Original Message-----


Select the Join line in the query design window and choose Option 2
(or 3): "Show all records in the User table and matching records in
the Information table".


.