I just started learning about inner joins and im suppose to get different values from two tables.
customer(table)
- name
- address
- postalcode
postdistrict(table)
- city
I have until now come up with this:
SELECT c.name, c.address, c.postalcode, p.city FROM customer c
INNER JOIN postdistrict p on c.name=p.city.
When executing it only gives me the header, but with no data in it. Can anyone tell me what im doing wrong or have missed? :)