Query on joined tables (more than 2 tables)greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I join 3 tables : - Company(ID,...) - Location(ID,IDComp,...) - Tel(ID,Tel,IDLoc) with the query : Select * From Company Where Company.ID = Location.IDComp And Location.ID = Tel.IDLoc And Tel.Tel Like "8202108" and I wait a very long time to get the result. Please tell me why and how to do faster.
-- Anonymous, October 12, 1998
Try using Tel.Tel = "8202108" rather than Tel.Tel Like "8202108".
-- Anonymous, October 18, 1998