why do you prefere inner join over select, i mean i was talking to a lot of people over some issues concerning the sql and everybody preferred join two tables over "select * from...where..."

is that better , faster, or just a different school.

for example i could do it by writing

select ... from TableA where y in (select ... from TableB)... or something like this

thanx