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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only