I am downloading product lines belonging to an order from a table using
Expand|Select|Wrap|Line Numbers
- SELECT '1' AS LineNumber, `products_model` AS Product,
- `products_quantity` AS Quantity, `products_price` AS Price,
- '' AS DiscValue, '0' AS LineTotalGross, `comments`
- FROM `orders_products`
- WHERE `orders_id` = '10560'
But I only want 'comments' to appear in the line 1 details of every order and line 2, 3 etc comments to be empty.
So I thought of using
Expand|Select|Wrap|Line Numbers
- CASE WHEN LineNumber > 0 `comments` = ''
Thanks in advance