lexilee1024
New member
- Local time
- Yesterday, 22:53
- 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..
This is URGENT
please answer me ASAP!
Thank you.
Every time I try the Query leaves out the mismatched information and only shows me the matched ones..
This is URGENT
please answer me ASAP!
Thank you.
Last edited: