Re: Migrazione dati
Thx for the reply
that is what I have want to read, now , to make the migration from the SQL to the access database I use a select that is :
SELECT
dbo.articoli.cod_articolo,
dbo.articoli.marca,
dbo.articoli_immagine.path_immagine,
dbo.articoli_immagine.path_2_immagine,
dbo.articoli_immagine.descrizione_web,
dbo.articoli_vendita.descr_1,
dbo.articoli.cod_famiglia,
dbo.listino_vendita.prezzo
FROM
dbo.articoli,
dbo.articoli_immagine,
dbo.articoli_vendita,
dbo.listino_vendita
WHERE
dbo.articoli.cod_articolo = dbo.articoli_immagine.cod_articolo
AND
dbo.articoli.cod_articolo = dbo.articoli_vendita.cod_articolo
AND
dbo.articoli.cod_articolo = dbo.listino_vendita.cod_articolo
AND
dbo.listino_vendita.cod_listino = 'BANCO €'
and listino_vendita.data_validita = (select max(lis_ven.data_validita) from listino_vendita as lis_ven where lis_ven.cod_articolo = articoli.cod_articolo and lis_ven.cod_listino = 'BANCO €' and data_validita <= getdate() )
AND
dbo.articoli.flg_ges_web = 'S'
and then I put the extracted colums to the new database.
How I can write the wbcopytable to have the same result?
Sry if I ask it but I'm not an expert of SQL so I need soe help.... :P
Subject
Written By
Posted
Re: Migrazione dati
June 03, 2015 02:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.