Advertisement
Braber01

SQL QUERY ERROR

Mar 28th, 2012
382
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. SELECT i.DateOpened, i.DateClosed, i.Title, c.Name,t.Name
  2. FROM dbo.Incidents AS i, dbo.Customers AS c, dbo.Technicians AS t
  3. WHERE i.CustomerID = c.CustomerID
  4. AND i.TechID = t.TechID;
  5.  
  6. /* the schema returned by the new query differs from the base query */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement