create a sql query

  • Thread starter Thread starter giminera
  • Start date Start date
G

giminera

My query in MSAccess is:
SELECT ArticoliMagazzino1.CodiceArticolo,
ArticoliMagazzino1.DescrizioneArticolo,
ArticoliMagazzino1.UmDiMagazzino, Query2.Prezzo
FROM ArticoliMagazzino1 LEFT JOIN Query2 ON
ArticoliMagazzino1.CodiceArticolo=Query2.CodiceArticolo
WHERE (((ArticoliMagazzino1.StatoRecord)=0));

Where Query2 is:
SELECT TabellaListiniArt.CodiceArticolo, TabellaListiniArt.Prezzo
FROM TabellaListiniArt
WHERE (((TabellaListiniArt.CodiceListino)="1") AND
((TabellaListiniArt.Stato)=0));

The problem is that I have to create a unique query.
Thanks in advance.
 
I'm not sure exactly what you mean. My first guess would be to just include
a 'distinct' in there...

SELECT distinct ArticoliMagazzino1.CodiceArticolo,....

but otherwise, could you give some sample data?
 
Back
Top