I have two similar tables, one outlining areas of work and the other outlining trips to that area. Table One shows the continuum of work, whereas Table Two shows fixed points in that continuum. I'd like to have one query which draws all information about this area of work. The pertinent column headings are the same (Area of Work; Organization; Started; Ended; Contact), and I'd like to be able to read the continuum and the fixed points in time in the same query, organized vertically.
Is this possible, without having them side by side?