yes it was typo and i did not check earlier thanks for your reply

ah i found issue in my query and have resolved it by writing logic on a paper 1st

the right query is as follows and its working for me

select pp.firstname +'_'+

pp.LastName...

Thanks for the reply champion

this is the main problem that i am not able to join Sales.SalesOrderHeader

I am joining this at the end as

sales.SalesOrderDetail.SalesOrderID  = sales.salesorderheader.salesorderID

but getting error message I...