I have 3 tables:
productID countryId price
1 Italy 90
1 England 110
productId productName productPrice
1 Book 100
2 Computer 1000
. ...... ...
Now, I have for example product Book.
I have to get the price for Book for each country, if the price doesn't
exist for that
country, the default price from table product should be used.
So, I need select statement, which returns the result for product Book:
Does anybody know the select statement?