F
Frank Oquendo
Let's say I have a query that looks like this:
SELECT Orders.*, Status.NAME
FROM Orders, Status
WHERE Orders.UserId = @UserID
AND Orders.StatusId = Status.StatusId
When I use that populate a DataSet via a DataAdapter, do I get two new
tables or one? What I want is a single table that is the amalgam of
both. Is this possible?
--
There are 10 kinds of people. Those who understand binary and those who
don't.
http://code.acadx.com
(Pull the pin to reply)
SELECT Orders.*, Status.NAME
FROM Orders, Status
WHERE Orders.UserId = @UserID
AND Orders.StatusId = Status.StatusId
When I use that populate a DataSet via a DataAdapter, do I get two new
tables or one? What I want is a single table that is the amalgam of
both. Is this possible?
--
There are 10 kinds of people. Those who understand binary and those who
don't.
http://code.acadx.com
(Pull the pin to reply)