MySql Hospital Management Database system : <p>How to diffentiate multiple column with same name I.e. patient table full name and doctor table full name</p>

<p>How to know the doctor that is assign to each patient.</p>

<p>Thanks</p>
