select one column in one table and select another from another in sql code example

Example: sql select all from one table and one column from another

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