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 ...