SELECT [mrd_no]
      ,[dtpRegDate]
      ,[cmbSuffix]
      ,[txtLastName]
      ,[txtFirstName]
      ,[txtmiddlename]
      ,[PatientName]
      ,[cmbgender]
      ,[txtDob]
      ,[txtAgeyear]
      ,[txtaddress]
      ,[Addr2]
      ,[cmbCity]
      ,[cmbdistrict]
      ,[cmbState]
      ,[txtmobile2]
      ,[txtmobile1]
      ,[Lang]
      ,[cmbconsultant]
      ,[cmbreferby]
      ,[InTime]
      ,[Checked]
      ,[txtAmount]
      ,[checkeye]
      ,[username]
      ,[year]
      ,[txtagemonth]
      ,[txtphone]
      ,[txtemail]
  FROM [NewPatient]

++++++++++++++++++++++++++++
SELECT  [MRD_NO]
      ,[Username]
      ,[Year]
      ,[PatientName]
      ,[PatientType]
      ,[InDate]
      ,[InTime]
      ,[OutTime]
      ,[Checked]
      ,[Consultant]
      ,[Dilated]
      ,[Dilatedtime]
      ,[Amount]
      ,[Suffix]
      ,[FirstName]
      ,[LastName]
      ,[Age]
      ,[RevisitDate]
      ,[ConsUser]
      ,[Refer]
      ,[Visit]
      ,[AddRow]
      ,[RWNO]
      ,[dialateapprov]
      ,[orgqno]
  FROM [QueueList]
+++++++++++++++++++

SELECT  [mrd_no]
      ,[VisitNo]
      ,[VisitDate]
      ,[year]
  FROM [visitdetails]
++++++++++++++++++++
SELECT  [mrd_no]
      ,[visitno]
      ,[visitdate]
      ,[ptname]
      ,[age]
      ,[gender]
      ,[txtcomplaints0]
      ,[txtcomplaints1]
      ,[txtcomplaints2]
      ,[cmbcompdays1]
      ,[cmbcompdays2]
      ,[cmbcompdays3]
      ,[cmbcompeye1]
      ,[cmbcompeye2]
      ,[cmbcompeye3]
      ,[cmbpasthistory]
      ,[chkdm]
      ,[txtdm]
      ,[cmbdm]
      ,[chkht]
      ,[txtht]
      ,[cmbht]
      ,[chkcad]
      ,[txtcad]
      ,[cmbcad]
      ,[chkprostate]
      ,[txtprostate]
      ,[cmbprostate]
      ,[chkcopd]
      ,[txtcopd]
      ,[cmbcopd]
      ,[txtothers]
      ,[cmbcategory]
      ,[cmbaddiction]
      ,[txtallergy]
      ,[txtocularhistory]
      ,[cmbglasstype]
      ,[cmbglassuses]
      ,[txtglassremark]
      ,[dilated]
      ,[txtar_sphre]
      ,[txtar_cylre]
      ,[txtar_axisre]
      ,[txtar_k1re]
      ,[txtar_k1axisre]
      ,[txtar_k2re]
      ,[txtar_k2axisre]
      ,[txtar_sphle]
      ,[txtar_cylle]
      ,[txtar_axisle]
      ,[txtar_k1le]
      ,[txtar_k1axisle]
      ,[txtar_k2le]
      ,[txtar_k2axisle]
      ,[txtarcyl_sphre]
      ,[txtarcyl_cylre]
      ,[txtarcyl_axisre]
      ,[txtarcyl_sphle]
      ,[txtarcyl_cylle]
      ,[txtarcyl_axisle]
      ,[txtiop_nctre]
      ,[txtiop_nctle]
      ,[txtiop_atre]
      ,[txtiop_atle]
      ,[txtioproplas_re]
      ,[txtioproplas_le]
      ,[txtvision_re]
      ,[txtpinhole_re]
      ,[txtvision_le]
      ,[txtpinhole_le]
      ,[txtpg_sphre]
      ,[txtpg_cylre]
      ,[txtpg_axisre]
      ,[txtpg_addre]
      ,[txtpg_sphle]
      ,[txtpg_cylle]
      ,[txtpg_axisle]
      ,[txtpg_addle]
      ,[txtrf_sphre]
      ,[txtrf_cylre]
      ,[txtrf_axisre]
      ,[txtrf_addre]
      ,[txtrf_visionre]
      ,[txtrf_nearre]
      ,[txtrf_sphle]
      ,[txtrf_cylle]
      ,[txtrf_axisle]
      ,[txtrf_addle]
      ,[txtrf_visionle]
      ,[txtrf_nearle]
      ,[username]
      ,[eyetodilate]
      ,[referby]
  FROM [OPDOPTO]

++++++++++++++++++
SELECT  [mrd_no]
      ,[visitno]
      ,[age]
      ,[visitdate]
      ,[ptname]
      ,[cmbocularre]
      ,[cmbocularle]
      ,[cmbbinacular]
      ,[txtorbitalre]
      ,[txtorbitalle]
      ,[cmblidsre]
      ,[cmblidsle]
      ,[cmbconjre]
      ,[cmbconjle]
      ,[cmbcorneare]
      ,[cmbcorneale]
      ,[txtcornearemarkre]
      ,[txtcornearemarkle]
      ,[cmbacre]
      ,[cmbacle]
      ,[cmbirisre]
      ,[cmbirisle]
      ,[cmbpupilre]
      ,[cmbpupille]
      ,[cmblensre1]
      ,[cmblensle1]
      ,[cmblensre2]
      ,[cmblensle2]
      ,[cmbnlpre]
      ,[cmbnlple]
      ,[txtfindingremark]
      ,[txtfindingremarkle]
      ,[txtfmedia0]
      ,[txtfmedia1]
      ,[txtfoptic0]
      ,[txtfoptic1]
      ,[txtfundusremark]
      ,[txtdiagnosis0]
      ,[txtdiagnosis1]
      ,[txtdiagnosis2]
      ,[txtbp]
      ,[txtadvice]
      ,[txtadviceremark]
      ,[txtreferto]
      ,[mskfollowdt]
      ,[continueothertt]
      ,[printglass]
      ,[username]
      ,[txtfundusremarkle]
      ,[txtatre]
      ,[txtatle]
      ,[txtiop_nctre]
      ,[txtiop_nctle]
      ,[ptlang]
  FROM [OPDCONSULTANT]
++++++++++++++++++++++
SELECT  [VoucherNo]
      ,[dtpDate]
      ,[MRD_NO]
      ,[PatientName]
      ,[cmbProcedure]
      ,[cmbConsultant]
      ,[txtAmount]
      ,[cmbMode]
      ,[txtCheckNo]
      ,[dtpCheckDate]
      ,[cmbGender]
      ,[txtAge]
      ,[txtMobile]
      ,[UserName]
      ,[Year]
      ,[Voucher]
      ,[txttime]
      ,[proctype]
      ,[txtnarr]
  FROM [ReceiptEntry]