Re: remove duplicate items

Il giorno Thu 14 Feb 2019 08:13:03p, *J.O. Aho* ha inviato su comp.databases.mysql il messaggio news:gclstvFfdh8U1_at_mid.individual.net. Vediamo cosa ha scritto:

> On 2/14/19 10:57 AM, Ammammata wrote:
>
> Maybe a group by would be in place when you select into the temp
> table.
>

>> select d.docnum, 'txt' Testo
>> into #tmp
>> 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'

this one works fine

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