Hi,

I have a data in table (example)
Table1
id name qty
1 Article 1 3
2 Article 2 2
3 Article 3 1

is there any solution if Firebird that I can write SQL statement which
will return this table in format
Table2
id name
1 Article 1
1 Article 1
1 Article 1
2 Article 2
2 Article 2
3 Article 3

whih mean that I get result table where avery record is multiplied
with qty, or how many rows are in resultset, that is represent a qty
column in table1.

Thanks for help!