JOIN Excludes Records

• Question

• 

  

  0

  Sign in to vote

  This join excludes records from the ticket database that do not have a customerID defined.  How do I correct this?  Thanks.

  SELECT        Ticket.TicketID, Ticket.TicketNumber, Ticket.TicketDate, Ticket.RRCNumber, Ticket.LeaseID, Ticket.Barrels, Ticket.StartTime, Ticket.StopTime,
                           Ticket.LineNumber, Ticket.Status, Ticket.Invoiced, Ticket.SWDNumber, Ticket.CustomerID, Ticket.DriverNumber, Ticket.CompanyNumber,
                           Ticket.ErrorDetected, Customer.[Customer Name]
  FROM            (Ticket INNER JOIN
                           Customer ON Ticket.CustomerID = Customer.CustomerID)
  WHERE        (Ticket.ErrorDetected <> '0') AND (Ticket.ErrorDetected <> '1') AND (Ticket.ErrorDetected <> '2') AND (Ticket.SWDNumber = ?)
  ORDER BY Ticket.TicketNumber, Ticket.TicketDate

   

  Wednesday, January 17, 2007 4:21 AM