Re: Query optimisation
From: programmer <int.consultNOCAPITALS_at_macmail.com>
Date: Wed, 6 Aug 2003 17:10:07 +0100
Message-ID: <bgr9o8$her$1_at_pheidippides.axion.bt.co.uk>
Date: Wed, 6 Aug 2003 17:10:07 +0100
Message-ID: <bgr9o8$her$1_at_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 - 18:10:07 CEST