![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 1.18 » View Incident Report |
![]() |
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 Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |