Re: remove duplicate items

[Quoted] Il giorno Thu 14 Feb 2019 12:27:30p, *Tony Mountifield* ha inviato su comp.databases.mysql il messaggio
news:q43jb2$rlr$1_at_softins.softins.co.uk. Vediamo cosa ha scritto:

> Alternatively, try replacing both queries with something like this:
>
> SELECT GROUP_CONCAT(DISTINCT d.docnum ORDER BY d.docnum SEPARATOR ' /
> ') FROM dln1 a
> INNER JOIN dln1 b ON a.U_I_BaseEntry = b.docentry AND a.U_I_BaseType =
> 15 INNER JOIN rdr1 c ON b.baseentry = c.docentry AND b.BaseLine =
> c.linenum AND b.BaseType = 17 INNER JOIN ordr d ON c.docentry =
> d.docentry WHERE a.docentry = '87'
>

tested right now:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'ORDER'.

-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
>>>>>  http://www.bb2002.it :)  <<<<<
........... [ al lavoro ] ...........