I need to join 2 tables, while only pulling the top 10 most frequent sku's from the sales.sales table.

```
Design.info table:
sku
name

sales.sales table:
basesku

```

I need to match "sku" from the design table to "basesku" from the sales table, and have the "name" column next to it.
Here's my current formula for receiving the top 10 designs from the sales.sales table:

```
SELECT basesku, count(*) FROM sales.sales GROUP BY basesku ORDER BY count(*) DESC LIMIT 10

```

A Colleague found a solution: 

```
SELECT sales.sales.basesku, count(*),design.info.name 
FROM sales.sales 
INNER JOIN design.info
On sales.sales.basesku = design.info.sku
GROUP BY basesku ORDER BY count(*) DESC limit 10

```