Query 2 tables in a sql database and display repeated values

Question

I have 2 tables in my database, a call pessoas and another call resultado, I am filling the table result with the draws made by mega sena, the table result has the fields:

data, dez1, dez2, dez3, dez4, dez5, dez6

Already the table people have the fields:

nome, dez1, dez1, dez3, dez4, dez5, dez6

I would like to make a select where show me exactly which balls people hit, in case show the tens that are equal in the two tables, they have no foreign key.

Answer 1

One way to do maybe not the best but nevertheless possible would be to do the following:

SELECT `pessoas`.`name`, `pessoas`.`dez1` FROM resultado
INNER JOIN pessoas ON `resultado`.`dez1`=`pessoas`.`dez1`

This returns all table records pessoas with values equal to dez1 table resultado. To obtain the remaining results it is enough to change the value 1 by 2, 3, 4, 5 and 6.

Real example in SQL Fiddle.

EDIT1

I managed to improve the query, example:

SELECT pessoas.name, pessoas.dez1 FROM pessoas
WHERE dez1 IN (SELECT dez1 FROM resultado WHERE data=140317)
OR dez1 IN (SELECT dez2 FROM resultado WHERE data=140317)
OR dez1 IN (SELECT dez3 FROM resultado WHERE data=140317)
OR dez1 IN (SELECT dez4 FROM resultado WHERE data=140317)
OR dez1 IN (SELECT dez5 FROM resultado WHERE data=140317)
OR dez1 IN (SELECT dez6 FROM resultado WHERE data=140317); 

In this query we select the first value of all people, and then we compare if it is equal to any of the 6 of the result. It also includes the condition to know how to look for the right day.

Real example in SQL Fiddle.