
Avoid error 1540 in Join queries
When you plan your queries, you should avoid the use of wildcard keyword * – which means “retrieve any field” – mainly because it may decrease performances, since the engine allocates space for the entire row; use explicit field declaration instead, such as:SELECT field1, field2 FROM table1 Moreover, consider the