Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 1.19 » View Incident Report |
Serious |
Reported By: Steve Forbes Reported On: 10/26/1999 For: Version 1.18 Build 1 |
{ The following SQL statement which should return the result set: Id Description ParentProduct Manager 1 New Product Steve Forbes 2 New Product Child New Product Phil Taylor 3 Another Child New Product Child } SELECT Product.Description, Product_1.Description AS ParentProduct, User.KnownAs AS Manager FROM (Product LEFT JOIN Product AS Product_1 ON Product.ParentId = Product_1.Id) LEFT JOIN User ON Product.ManagerId = User.Id ORDER BY Product.Description
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |