excel has all data in one row code example

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

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

Example 2: select all columns except one by name in r

mtcars[, -which(names(mtcars) == "carb")]