Posted on: 11/13/2014 5:31:46 PM | Views : 507

hi,
i have 3 tabels which are Doctor, Patient and DoctorPatient.
i have column names called FirstName, MiddleName,LastName in both Doctor and Patient this is sql query below and

@"select d.DoctorId,d.FirstName,d.MiddleName,"                             + "d.LastName,p.PatientID,p.FirstName,p.MiddleName,P.LastName from DoctorPatient as dp"                             + "join Doctor as d "                             + "on d.DoctorId=dp.DoctorId "       ...

Go to the complete details ...