sel distinct location.locno location.location from location, tranmaster where location.districtno='67959' and tranmaster.districtno='67959' and location.locno=tranmaster.locno and trantype='HMP' and locno is not null order by location
do you mean instead of location.locno=tranmaster.locno i just do locno=locno? ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, December 02, 2004 9:52 AM Subject: [RBASE-L] - Re: Propper SQL > > They both run and return results, I was just wondering if the first form was > > incorrect or not? > > They're both OK, although in the first example you don't need to qualify the > same column in both tables -- because of the join, one table will do. > > It's a matter of which returns faster. > -- > Larry >
