0

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
Improve this question
6
  • 2
    This should return results from both tables, unless there are duplicate column names. Those will only come from one table. Commented Nov 21, 2023 at 20:55
  • That's precisely what I'm expecting as well, and yet, in this case it's only returning results from the Invoice table and nothing from Customer. Commented Nov 21, 2023 at 20:57
  • Maybe it's a problem with DB Browser, try using another query interface. Commented Nov 21, 2023 at 20:58
  • The problem was me. I'm even embarrassed how dumb it was that I didn't just use the scroll bar to scroll and assumed my mouse scroll worked correctly in the application (it does not). Commented Nov 21, 2023 at 21:01
  • 1
    Workbench on a laptop? My scroll never works for Workbench installed on Windows -- Especially touch pad. Commented Nov 21, 2023 at 21:03

1 Answer 1

Reset to default
0

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

What's a PICNIC error? Is it like PEBKAC?
Yup, "Problem In Chair, Not In Computer".

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.