Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `table1.partnumber`,
- `table1`.`price`,
- `maintable`.`price`
- FROM `table1`
- INNER JOIN `maintable`
- ON `table1`.`partnumber` = `maintable`.`partnumber`
- UNION ALL
- SELECT `table2`.`partnumber`,
- `table2`.`price`,
- `maintable`.`price`
- FROM `table2`
- INNER JOIN `maintable`
- ON `table2`.`partnumber` = `maintable`.`partnumber`
- UNION ALL
- SELECT `table3.partnumber`,
- `table3`.`price`,
- `maintable`.`price`
- FROM `table3`
- INNER JOIN `maintable`
- ON `table3`.`partnumber` = `maintable`.`partnumber`
- SELECT `partnumber`,MIN(`price`) as `price`
- FROM (
- SELECT `table1`.`partnumber`,
- `table1`.`price`,
- `maintable`.`price`
- FROM `table1`
- INNER JOIN `maintable`
- ON `table1`.`partnumber` = `maintable`.`partnumber`
- UNION ALL
- SELECT `table2`.`partnumber`,
- `table2`.`price`,
- `maintable`.`price`
- FROM `table2`
- INNER JOIN `maintable`
- ON `table2`.`partnumber` = `maintable`.`partnumber`
- UNION ALL
- SELECT `table3.partnumber`,
- `table3`.`price`,
- `maintable`.`price`
- FROM `table3`
- INNER JOIN `maintable`
- ON `table3`.`partnumber` = `maintable`.`partnumber`
- ) AS `part` GROUP BY `partnumber`
- SELECT partnumber, MIN(price) FROM (
- SELECT 1 AS tn, partnumber, table1.price
- FROM table1 JOIN maintable USING (partnumber)
- UNION ALL
- SELECT 2 AS tn, partnumber, table2.price
- FROM table2 JOIN maintable USING (partnumber)
- UNION ALL
- SELECT 3 AS tn, partnumber, table3.price
- FROM table3 JOIN maintable USING (partnumber)
- ) t
- GROUP BY partnumber
- HAVING COUNT(DISTINCT tn) >= 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement