query from 2 tables

From: maggie (anonymous_at_discussions.microsoft.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 09:42:11 -0800

Table 1 has a field called "father first name", one
called "father last name", and one called "father
address". Table 2 has a field called "grandfather first
name", one called "grandfather last name", and one
called "grandfather address". The two tables can be
joined together by a field called "student number", as
they are related to the same student. I want a query
that will take the father information (from table 1) and
put it into fields called "first name", "last name",
and "address". So far, not a problem. I can do this
part. But now I also want the grandfather information to
be to be put into these same fields (first name, last
name, address) as a separate record from the father. How
would I write the query so that I get the father's
information on one line of the query result, and the
grandfather information on another line of the query
result? But into the same field names? I hope this
makes sense. Your assistance is appreciated.

Relevant Pages

  • Family Bible and census.
    ... I have a family Bible handed down from my great great grandfather. ... My grand father was a Canal boatman. ... John married Jane. ... Issachia married ...
    (soc.genealogy.britain)
  • Re: OT: Gettysburg
    ... 1184152350.357279.238340@xxxxxxxxxxxxxxxxxxxxxxxxxxx, "dick thaxter" ... My mother's Grandfather, Francis Asbury Shoup was a Confederate --a ... And her Father was named for his colleague, ... My uncle tells me we have a Simpson ancestor who was ...
    (rec.music.makers.guitar.acoustic)
  • Re: William Davison
    ... and was a Scotisman at hart', but hardly anything is known about his ... background or his personal life ... I have his father as Richard (b. ... and his grandfather as Francis (b. ...
    (soc.genealogy.medieval)
  • Re: OT -- Re: Very bad news today in RMSs extended modelling communityof Lancaster PA
    ... I agree with that, Bill. ... The concept that my father and grandfather had of ... self-reliance is pretty-much gone in today's culture; ...
    (rec.models.scale)
  • RE: Totally Baffled - Sleuths wanted......
    ... let me offer the following scenarios which may provide an answer to ... When researching my grandfather Lewis Fink in Manchester, ... Father: Woolf Eisenstein ... Mother: Sara Eisenstein ...
    (soc.genealogy.jewish)