Sql 2000 Pls Help!!!

[dpavlidoy]

Kalispera sas,

exo to eksis provlima kai tha to ektimousa an mporousate na me voithisete.

Exo ftiaksei mia report stin opoia mou emfanizei tis poliseis.

Mesa stis poliseis omos xrisimopoioun ektos apo eidoi kai ipiresies, ego thelo na eksaireso tis ipiresies oste na vlepo kathara tis poliseis ton eidon.

Exo dokimasei diaforous tropous alla den ta katafera,an mporei kapoios na me voithisei:cry:

Parakato tha deite ton kodika pou egrapsa:

SELECT DocSer.Title,

DocHdSal.ID AS DOCHDSAL_ID ,

LItmSale.LinkID,

Material.Description,

LItmSale.Quantity,

LItmSale.Price,

LItmSale.NetValue,

LItmSale.TotalValue,

DocHdSal.SeriesCode

FROM LItmSale

LEFT JOIN DocHdSal WITH (READUNCOMMITTED)

ON (LItmSale.DocumentAA = DocHdSal.AA)

INNER JOIN DocSer WITH (READUNCOMMITTED)

ON (DocHdSal.SeriesCode = DocSer.Code)

LEFT JOIN Client WITH (READUNCOMMITTED)

ON (DocHdSal.PersonID = Client.PersonID)

LEFT JOIN Material WITH (READUNCOMMITTED)

ON (LItmSale.LinkIDNum = Material.AA)

LEFT JOIN StrgLocT WITH (READUNCOMMITTED)

ON (LItmSale.StrgLocAA = StrgLocT.AA)

 

Euxaristo

[sotospez]

ama den kseroyme tin basi pos na se boithisoyme den an exei flag o pinakas ton eidos poy na xorizi an einai ipiresia i eidos kane kritirio kai meta join

 

select code,sum(q) as pos ,sum(a) as amount

from polisis,eidi

where polisis.eidiid = eidi.eidiid

and eidi.flag = 1

 

kati tetio