Re: Query optimisation

From: programmer <int.consultNOCAPITALS_at_macmail.com>
Date: Wed, 6 Aug 2003 17:10:07 +0100
Message-ID: <bgr9o8$her$1@pheidippides.axion.bt.co.uk>

> Two tables Locations and Data
> Locations has PK Location Key Id
> Data has FK Location Key Id
>
> The query
>
> SELECT *
> FROM locations
> WHERE locations.[location key id]
> IN
> (SELECT distinct Data.[Location Key Id]
> FROM Data
> WHERE Data.[Customer Key Id]= " & G_Customer_Key_Id & ");"

SELECT *
FROM locations, data
WHERE Data.[Customer Key Id]= " & G_Customer_Key_Id & ")" and locations.[location key id] = Data.[Location Key Id]; Received on Wed Aug 06 2003 - 11:10:07 CDT