Basic Join Query Not Yielding All Columns when using "Select *"

41 views Asked by At

I'm taking a SQL Essentials training course. It's time to learn Joins and the instructor is having us use DB Browser. So far, everything has worked great; until this lesson.

The instructor has us make a query that will join a customer and invoice table and then give all columns using 'SELECT *'. My query works, but all it's giving me are the results from one table, not both.

In the video, the instructor is doing exactly the same thing I'm attempting and he's getting results. I'm wondering if this is as simple as a setting in the application itself.

I've tried specifically selecting columns from both tables and that works as expected, but when I try to select all, it still only gives the results to one table. The query is dead simple.

SELECT
    *
FROM
    Invoice
INNER JOIN
    Customer
ON
    Invoice.CustomerId = Customer.CustomerId
ORDER BY
    Customer.CustomerId
1

There are 1 answers

4
Extra Fox On

This is a classic PICNIC error.

The results were displayed, but when I scrolled left and right, it skipped past the columns I thought were missing.

Apologies for the fire drill, please feel free to close this question.