> person.*,place.* as home_*
> person.home_id = place.id
> name = 'Joe'
What if more of your tables have a column "name"?
> To get back results like:
> The problem is that I don't want to have to update my queries everytime I
> add a new column, so I use table_name.* a lot. But then if I ever add a
Really? That's stupid :-) ... Ask only for the columns you need:
the rest is increased network traffic.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL