Select differences between two sql tables

Navigation
-1

I need to select all the fields of the entries that have differences between two columns of two different tables.

tables: wow_eu_leadder_3v3 and wow_eu_leadder_3v3_old columns to check: rating and ranking

    
asked by Akond 21.10.2017 в 18:04
source

1 answer

0

This worked for me: 

SELECT DISTINCT a.*
FROM wow_eu_leadder_3v3 a,wow_eu_leadder_3v3_old b
WHERE a.name = b.name
  AND a.realm_id = b.realm_id
  AND a.rating <> b.rating;
    
answered by 22.10.2017 в 18:05
why do I get these php errors? Pass elements from a listbox to a two-dimensional array [closed]