只需使用表名:

SELECT myTable.*, otherTable.foo, otherTable.bar...

这将从myTable中选择所有列，并从otherTable中选择foo和bar列.

That would select all columns from myTable and columns foo and bar from otherTable.