On 22 Oct, 15:55, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> 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!

"Subquery returns more than 1 row" is the error )