in vb6.0
Dim rs As New ADODB.Recordset
If rs.State = 1 Then rs.Close
rs.Open "select m.DCH_Date ,d.DCH_Date from Deposite_Cheque_Master as m, Deposite_Cheque_Detail as d where m.DCH_Id =d.DCH_Id and m.DCH_Id = 1", cn, adOpenDynamic, adLockOptimistic
'================================== Works when database in MS Access =================
Debug.Print rs.Fields("m.DCH_Date")
'=============================================================
'================================== doesn'n Work when database in sql 2005 =================
Debug.Print rs.Fields("m.DCH_Date")
'=============================================================
pls reply....
Thank you