By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Check Out This Code Please..........

100+
P: 103
rs1.Open "select empdetail.id,saldetail.name where empdetail.id = saldetail.id", conn, adOpenStatic, adLockOptimistic
PLesae it is too selct 2 columns from 2 different tables?????
Jan 14 '08 #1
Share this Question
Share on Google+
1 Reply


QVeen72
Expert 100+
P: 1,445
Hi,

Try this :
Expand|Select|Wrap|Line Numbers
  1. rs1.Open "select empdetail.id,saldetail.name From EmpDetail, SalDetail where empdetail.id = saldetail.id", conn, adOpenStatic, adLockOptimistic
  2.  
Regards
Veena
Jan 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.