Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT i.DateOpened, i.DateClosed, i.Title, c.Name,t.Name
- FROM dbo.Incidents AS i, dbo.Customers AS c, dbo.Technicians AS t
- WHERE i.CustomerID = c.CustomerID
- AND i.TechID = t.TechID;
- /* the schema returned by the new query differs from the base query */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement