Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- pa.id
- ,pad.id
- ,pa.avalaible_gen
- ,pad.avalaible_gen
- ,pa.price_torg
- ,pad.price_torg
- ,(pa.price_torg - pad.price_torg) AS 'price_diff'
- FROM `prices_all` pa
- LEFT JOIN `prices_all_duplicate_21_12_18_2` pad ON pa.id = pad.id
- WHERE 1=1
- -- AND pa.avalaible_gen != pad.avalaible_gen
- AND pa.price_torg != pad.price_torg
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement