select rm.doc,rm.name,pd.address,volumename=(select vaolum from CDMaster where di.code =Cdmaster.code) From RegistrationMaster RM inne rjoin Partydetails pd on rm.doc=pd.doc inner join DocumentInfo DI on rm.cdcode=DI.cdcode
please
send linq for that sql query
how can i get this
(select vaolum from CDMaster where di.code =Cdmaster.code)
other than this i got all fields