...
The query above would produce a chart with product names (PNAME) as labels and prices (PPRICE) as values.
Code Block | ||
---|---|---|
| ||
SELECT PNAME, PCNAME, PSTOCK FROM PUISAMPLES/PRODP |
The query above would produce a chart with produce names concatenated with category names (without spaces between the fields), and stock numbers (PSTOCK) as values.
Code Block | ||
---|---|---|
| ||
SELECT PNAME || ' ' || PCNAME, PSTOCK FROM PUISAMPLES/PRODP |
...