join two diffeerent tables
i have one table called custsales on my machine and and with same table name on different machine.That talbe has field date and storeid.now when i select date and storeid from different machine(using IP address) all values of that storeid and of that selected dast should be copied to my local machine database and in table called custsales.how can i do that in vb.net.i appriciate ur help.its urgent please
thanx
If I understand your problem correctly, you don't need to code in VB for this. From SQL Analyser use something like the following...
select storeid, date into localDB..custsales from remotDB..custsales where....
Mitch
http://www.enterpriseetc.com