I have table (SQL MS ACCESS)
COUNTRY NO_OF_PAGES FRANCE 2 UK 4 GERMANY 1
I want output
COUNTRY NO_OF_PAGES FRANCE 1 FRANCE 2 UK 1 UK 2 UK 3 UK 4 GERMANY 1
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
I create number table which contain value from 1 to 10,you may populate it with more as per your requirement.
Table name tblNumber (RowNumber number) SELECT country, rownumber FROM tblNumber AS N INNER JOIN table3 AS t ON n.rownumber<=t.noofpages;
here table3 is your table.