Code: Select all
SELECT surname,addressname,add1,add2,town,county,postcode FROM addressModerator: General Moderators
Code: Select all
SELECT surname,addressname,add1,add2,town,county,postcode FROM addressCode: Select all
SELECT surname,addressname,children, CONCAT_WS(', ','add1','add2','town','county','postcode') AS 'add',phone,mobile,email,email2 FROM address ORDER BY surname"