hey (1 Viewer)

lexilee1024

New member
Joined
Apr 8, 2016
Messages
1
I have 2 querys. The first one contains information about student number, name and grade. The other one has information on student number, name height and weight. I combined the two querys together by matching the student number and name. So five information shows on one query. Here is the problem. On Query #1 there is information on student named Jack but there is no information on him on Query #2, So I stil want to include him but leave the height and weight blank. How would I do that?
Every time I try the Query leaves out the mismatched information and only shows me the matched ones.. :confused:
This is URGENT
please answer me ASAP!
Thank you.
 
Last edited:

pbaldy

Wino Moderator
Staff member
Joined
Aug 30, 2003
Messages
33,671
Right click or double click on the join line to edit it. The correct choice should be obvious.

FYI, I moved your thread out of the introductions forum.
 

yupstrips

New member
Joined
Mar 26, 2016
Messages
9
Thanks for sharing this useful info....
 

NauticalGent

Executive Troll
Joined
Apr 27, 2015
Messages
2,448
Ya know Grumm, I was thinking the same thing...the fact that this was in the introduction thread and was his/her initial post supports your theory.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom