Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    4

    Angry Unanswered: Queries view records

    Hello everyone,

    I have multiple views that I'm making so end users can run them as precanned reports. I keep running into the same issue for many of them though. When I create a view that is based off of multiple tables my results are not always complete. Ex. I have one where I'm pulling dates from various tables based off a job #. As long as there is a related record in each table I get the result; however, lets say if my table that holds approvals & status doesn't have a related record then that job doesn't get pulled up at all. Now I understand why (because there's no related record), but is there a way I can get around this and display the information I do have.

    Thanks for any advice
    Last edited by abliss; 02-17-10 at 15:02.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Look up outer joins.

  3. #3
    Join Date
    May 2009
    Posts
    4
    Thanks for the pointer Crowley got it done.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •