creating a query sql

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 for use with SQL.
Thanks in advance.(giminera@.libero.it) writes:
> 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 for use with SQL.
> Thanks in advance.
I'm not sure what your question is. But since this is a newsgroup about
SQL Server, I will produce a query that works on SQL Server, without
considering whether it would work on Access. (Since I don't know Access,
I can't consider it anyay.)
SELECT AM.CodiceArticolo, AM.DescrizioneArticolo,
AM.UmDiMagazzino, TLA.Prezzo
FROM ArticoliMagazzino1 AM
LEFT JOIN TabellaListiniArt TLA ON AM.CodiceArticolo = TLA.CodiceArticolo
AND TLA.CodiceListino = "1"
AND TLA.Stato = 0
WHERE AM.StatoRecord = 0;
I've taken the liberty to introduce aliases, and to remove the exesses
of parentheses.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx