I'm very new to ms sql and joins. Please can someone guide me through this process.

The query below works, however it duplicates a lot of columns that are in both tables.

```none
Select *
From ['BP Ref _ Customer Name$']
inner join ['Road 2010 - Current$']
on ['BP Ref _ Customer Name$'].[Client Order]=['Road 2010 - Current$'].[Client Order]

```

However, when I try to specify the columns I want the query to select in ['BP Ref \_ Customer Name$'] table I get an error.