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

SQL in Data Adapter Conf. Wizard

P: n/a
I am trying to use SQL statement in my Data Adapter
Configuration wizard. Can anyone help me to write a query
which will selest some field from different tables from a
relational database and write these fields into another
database? Or is there any other better way to do it?
Thanks in advance
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "M Sameer Haider" <an*******@discussions.microsoft.com> scripsit:
I am trying to use SQL statement in my Data Adapter
Configuration wizard. Can anyone help me to write a query
which will selest some field from different tables from a
relational database and write these fields into another
database? Or is there any other better way to do it?


For database-related questions, consider posting to this group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
<URL:http://dotnet.mvps.org/dotnet/faqs/>
Nov 20 '05 #2

P: n/a
SELECT Customers.CustomerID, Customers.CompanyName, Orders.RequiredDate,
Orders.ShippedDate INTO NEWTABLENAME
FROM Customers INNER JOIN Orders ON Customers.CustomerID =
Orders.CustomerID;

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

"M Sameer Haider" <an*******@discussions.microsoft.com> wrote in message
news:39****************************@phx.gbl...
I am trying to use SQL statement in my Data Adapter
Configuration wizard. Can anyone help me to write a query
which will selest some field from different tables from a
relational database and write these fields into another
database? Or is there any other better way to do it?
Thanks in advance

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.