Does the MySql Table Adapter or Query Builder allow sub queries like the following example?

Does the MySql Table Adapter or Query Builder allow sub queries like the following example?

Postby Guest » Mon 07 Aug 2006 02:08

Does the MySql Table Adapter or Query Builder allow sub queries like the following example?

SELECT ProductID, ProductName, SupplierID, CategoryID,
QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued,
(SELECT CategoryName FROM Categories
WHERE Categories.CategoryID = Products.CategoryID) as CategoryName,
(SELECT CompanyName FROM Suppliers
WHERE Suppliers.SupplierID = Products.SupplierID) as SupplierName
FROM Products
Guest
 

Postby Serious » Mon 07 Aug 2006 07:56

We tested query
Code: Select all
select ename, (select dname from dept where deptno=emp.deptno) as dname from emp
It is unable to use this query with CS2005 Configuration Wizard, but you can create Table Adapters with DataSet Wizard.

Note that we found a problem in DataSet Wizard: when creating Table Adapter columns in the table are not generated. This problem will be fixed in the next build, which becomes available in a few days. To avoid this problem in current version just press "Configure" on created Table Adapter, columns will be generated.
Serious
 


Return to dotConnect for MySQL