I've started getting an inspection hint along the lines of:
column aliases required for 'a(addressid:number, number:number, postcode:number, firstline:number, firstline:string)'
This is apearing at, in this case the table alias for `address` in the update statement below.
ORDER BY l.addressline SEPARATOR ' '
) AS firstline
WHERE a.addressid = l.addressid
GROUP BY l.addressid
ORDER BY l.addressline);
I'm getting similar warnings on tables within select statements when there are multiple `joins`.
Can anyone suggest what the warning actually means?