Re: Strange results

Charles,
I do not see it. If I strip out my qualifiers, I'm joining building to premise then bill_acct to premise.
Isn't a Cartesian join where you join one table to another where there is no key the same between them?

Thanks
Tom

Oh and for the correct code it's

Select distinct     a.AD_SERV_CITY,
                          a.cd_city_cnty,
                          d.ky_ba,
                          d.ky_prem_no
                          from building a,
                          premise c,
                          bill_acct d
                          where
                          ((a.cd_city_cnty     in ('0627')
                           and a.KY_BLDG_NO   = c.KY_BLDG_NO
                           and c.ky_prem_no   = d.ky_prem_no
                           and d.cd_ba_stat   = '02')
                           or (upper(a.AD_SERV_CITY) like '%BYRNES
 MILL%'))
                           order by 1, 3, 4 ;