i solve it. thank you so much. and more simple question, i push 'qouted'...

i solve it. thank you so much. and more simple question, i push 'qouted' button for you. is it give mark for you??

ok, solved :).

thank you very much Greg.

its okey now, thank you very much ALL friends :)).[/b]

this is code for other people, maybe they will need :))

ALTER VIEW [dbo].[vwPurchase]

AS

Select DISTINCT

...

i did like that..

ALTER VIEW [dbo].[vwPurchase]

AS

Select distinct

min(pur.InPurchaseId),

pur.StNotes,

...

i did like you as..

ALTER VIEW [dbo].[vwPurchase]

AS

Select distinct

min(pur.InPurchaseId),

pur.StNotes,

Convert(varchar(20),pur.DtProcDTime,104) as StProcDTime,

ac1.StAccountName,

ac2.StAccountName as StCompanyName,

CAST(pur.BoIsActive AS varchar(5)) AS BoIsActive

from

TbPurchase as pur

INNER JOIN

TbAccounts as ac1 On ac1.InAccountsId=pur.InOurRelevantId

INNER JOIN

TbCompanies as comp ON comp.InCompaniesId=pur.InCompanyId

INNER JOIN...

i want to see first one with its ID

Firstly thank you very much friends.

these datas a pieace of my view. see 8,9 coloums. they have same datas. but i cant distinct

vwPurchase

1Güven Büro Mobilya ...