-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: vikupal2003
Message 1 in Discussion
dear all, I am working on sqlXML concept in the mssql2000, follwoing is the
query, the database is northwind SELECT Customers.CustomerID,
Customers.ContactName,<o:p></o:p>Orders.ShipCity, Employees.FirstName + ' ' +
Employees.LastName as<o:p></o:p>_EmployeeName, Employees.Region<o:p></o:p>FROM
Customers INNER JOIN<o:p></o:p> Orders ON Customers.CustomerID = Orders.CustomerID
INNER JOIN<o:p></o:p> Employees ON Orders.EmployeeID =
Employees.EmployeeID<o:p></o:p>WHERE (Customers.CustomerID IN ('ALFKI', 'TRAIH')) for
xml auto<o:p></o:p> I am getting the following out put <Customers CustomerID="ALFKI"
ContactName="Maria Anders"><o:p></o:p> <Orders ShipCity="Berlin"
EmployeeName="Michael Suyama"><o:p></o:p> <Employees /><o:p></o:p>
</Orders><o:p></o:p> <Orders ShipCity="Berlin" EmployeeName="Margaret
Peacock"><o:p></o:p> <Employees Region="WA" /><o:p></o:p> <Employees
Region="WA" /><o:p></o:p> </Orders> -------------------------
------------------------- etc. can any one plz tell me why EmployeeName attribute is
comming in the orderselement, if i change the query like<o:p></o:p> <o:p>SELECT
Customers.CustomerID, Customers.ContactName,<o:p></o:p>Orders.ShipCity,
Employees.Region, Employees.FirstName + ' ' + Employees.LastName
as<o:p></o:p>_EmployeeName FROM Customers INNER JOIN<o:p></o:p> Orders ON
Customers.CustomerID = Orders.CustomerID INNER JOIN<o:p></o:p> Employees ON
Orders.EmployeeID = Employees.EmployeeID<o:p></o:p>WHERE (Customers.CustomerID IN
('ALFKI', 'TRAIH')) for xml auto then i am geting the results properly.
regardsvijay</o:p>
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
