>Hi,
>
>before, optimize this:
>

>SELECT COUNT(Deceased.*) FROM Deceased JOIN ZipCross ON Deceased.Zip=Zipcross.Zip
>JOIN AreaOrder C ON B.AreaID=C.AreaID AND C.CampaignID=300
>

>
>How much time is necessary for this query?
>
Hi Fabio,

This query will take 0 seconds ( as an original one) because they both are invalid. There's no 'B' table or table alias in the either query. :)