SELECT id,data,
(SELECT namePokup FROM pokup WHERE id=idNamePokup),
(SELECT nameTovar FROM tovar WHERE id=idNameT),
idPrihod,
(SELECT name FROM edIz WHERE id=idEd),
kolvo,
cena,
kolvo*cena AS Сумма,
(SELECT name FROM valuta WHERE id=idValuta)
FROM rashod WHERE idNamePokup=1