select address1 , address2 , address3 , post_code from country c inner join address a on a . country_id = c . id where c . country_name = 'Scotland' :) - I know, terrible isn't it; I thought with the gloomy Autumn weather we now have, setting off in the dark etc... an oh no joke was the order of the...