Skip to content
Advertisement

Table shows DISTINCT information when I tell it not to?

For some reason I keep getting an output with DISTINCT information. I am trying to understand JOINS and I am not sure why I am getting this output:

Here is what i have tried and above is the output:

What I am trying to do is list all of the manufacturer names with their associated models.

Scripts to Repro the issue:

Advertisement

Answer

You have to include tblBrand to link the manufacture with model. So regular inner joins:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement