# Select all columns from the joined table and some from the other

> This would select all the columns from the myTable. Got it from here

- Canonical: https://preview.arshadmehmood.com/today-i-learned/sql/select-all-columns-from-joined-table-and-some-from-other-table/
- Section: sql
- Author: Arshad Mehmood

This would select all the columns from the `myTable`.

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

Got it from [here](https://stackoverflow.com/questions/3492904/mysql-select-all-columns-from-one-table-and-some-from-another-table)