sql server misc: hi i'm new areound here so i dont know if i'm posting in the right news
group... i have a litlle problem...

i have a table with a product id and quantity on stock then i have a table
where my partners product id i conected to my product id ... and then i have
a insert into statemanet that connects product id of partner and my product
and puts all that data into a temp table.. and it works fine..
then i'm trying to get all the data from the tmpZaImport table even if its
not in the Table_sifre_proizvoda ... the same thing for tblProdajaDetalji
....

can you help me..?!


SELECT dbo.Table_sifre_proizvoda.Nasa_sifra_proizvoda,
dbo.Table_sifre_proizvoda.Partnerova_sifra_proizvoda,
dbo.tblProdajaDetalji.SDC AS UDC,
dbo.tmpZaImport.Stanje
FROM dbo.tmpZaImport INNER JOIN
dbo.Table_sifre_proizvoda ON
dbo.tmpZaImport.Partnerova_sifra_proizvoda =
dbo.Table_sifre_proizvoda.Partnerova_sifra_proizvoda RIGHT OUTER JOIN
dbo.tblProdajaDetalji ON
dbo.Table_sifre_proizvoda.Nasa_sifra_proizvoda =
dbo.tblProdajaDetalji.ID_product
WHERE (dbo.Table_sifre_proizvoda.ID_partnera = '1') AND
(dbo.tblProdajaDetalji.ID_ProdajaOsnovno = '1')

i forgot to write part of code thats befor select statment

INSERT INTO tmpStaroStanje (ID_product, PartnerSifra, SDC)

andy