Hi
>I hate this because when you use a very complicated statement which takes many rows and you are in WHERE clause sometimes you can't remember which tables is A, which is B etc. Better use aliases with more letters that will tell you with what table you work. If the table name is smaller than 10 letter then don't use alias at all. This is of course only my opinion.
when you comment i think of that, i read sometime ago, here or in other place i don't remember now where, that's better to prefix the tables, for better reading and not make some confusion when tables as same fields names, where clauses like you said, i only do this's in test queries and small ones... for not writing alot :) ...
By the way ... i think your sample works...thank's, move them to the real place and see ...
João Batista
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement