On 22 Oct, 15:33, UKuser <spiderc...@yahoo.co.uk> wrote:
> Hi,
>
> What am I doing wrong with this statement?
>
> UPDATE company
> SET new_test =
> concat_ws(
> (
> Select Property from `properties` where `Company_ ID`=1
> )
> ,'#')
> WHERE
> company.`Company_ ID`=1
>
> I want it to insert Property into the field new_test separated by a #
> but it errors on me.
>
> Any would be great.
>
> Thanks
>
> A

"it errors on me"
Wow, how bl**dy useful. If my crystal ball was working I could of
course see what error you were getting. But it isn't.

So, would you care to tell us!