SQL in Data Adapter Conf. Wizard

[M Sameer Haider]

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

 

[Herfried K. Wagner [MVP]]

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:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>

 

[One Handed Man \( OHM - Terry Burns \)]

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