dear All,
now i am using sql server for database for my application.while I am using a query it give multiple records.I double checked with query analyser but no impact. please help..
the query:
“select domains.domainid,domains.dvendor,domains.dexpirydate,domains.wspace,domains.wexpirydate, clients.organisation, enquiry.dateoffollowup from domains inner join clients on domains.organisation=domains.organisation inner join enquiry on clients.organisation=enquiry.organisation order by enquiry.enquiryid ”
I tried with another one
2)’rs.Open “select domains.domainid,domains.dvendor,domains.dexpirydate,domains.wspace,domains.wexpirydate,clients.organisation,enquiry.dateoffollowup from domains inner join clients on domains.organisation=domains.organisation inner join enquiry on clients.organisation=enquiry.organisation order by enquiry.enquiryid ”
any one have idea?
Thanks in advance
melvin