Hey everyone, I'm trying to do something and was wondering which was more propper sql or if they were both equaly valid
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 that's the first form, I select columns from a single table even though I have 2 tables in the table list and 2 tables in the where clause, is that a bad thing or is it ok as far as sql syntax is concerned sel locno location from location where districtno='67959' and locno in (sel locno from tranmaster where districtno='67959' and trantype='hmp' and locno is not null) order by location thats the second one, I'm using a subselect instead of a join. They both run and return results, I was just wondering if the first form was incorrect or not? Thanks! Alan
