Can I link 2 SQL tables?

I've never made a pivot table before (always used a report software) but now I have a need to for simplification. All I need to get is 3 columns of information live into Excel, which will come from two SQL tables within the same SQL database. I have created the data sources, and I can successfully bring in one live column at a time. If I check off two fields from one table, the information comes into Excel in a single column, stacked into the same cell for each item. Basically, from the two SQL tables I need "Item No.", "Description", and "Quantity On_Hand". I need each of these fields to be in its own column in the Excel worksheet. How do I link these together and bring them in correctly?

Thanks

This works, thanks!