Hi,
i want to get data from 2 tables [ in sqlserver ] using ado.
my query :
how can i achieve this.
------------ code -----------------
sqlstatuser = "select usrid from tbmuser where deptid='A3' and
recstatus='Y' and usrid in (" & _
"'select empno from rightmst where formname ='mnuVendor' and
newright='Y')"
Set rstusers = New ADODB.Recordset
rstusers.CursorType = adOpenStatic
rstusers.CursorLocation = adUseClient
rstusers.Open sqlstatuser, cnn1, , , adCmdText
----------------
it is givint error at 'mnuvendor'
thankyou.
phani
