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
Thanh Nhon,Try using Tel.Tel = "8202108" rather than Tel.Tel Like "8202108".
Eric
-- Anonymous, October 18, 1998