Trouble finding matches

[ChetUbetcha]

I have 2 tables. Each has NAME and PERCENT. I need to find all the NAME matches in both tables that have different PERCENTs.

SELECT * FROM table1, table2 WHERE table1.name = table2.name AND table1.percent != table2.percent

I've tried JOINS, building arrays from both. I need to list NAME, followed by PERCENT from table1 and PERCENT from table2 on one screen, then I can display the difference.

[Derokorian]

SELECT table1.name,table1.percent,table2.percent FROM table1 INNER JOIN table2 ON table1.name = table2.name AND table1.percent <> table2.percent