Advertisement
Guest User

Untitled

a guest
Feb 5th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. SELECT partNum,
  2. COALESCE(engPriceTable.price, regPriceTable.price)
  3. FROM engPriceTable,regPriceTable,table1
  4. WHERE engPriceTable.partNum=table1.partNum OR
  5. regPriceTable.partNum=table1.partNum
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement