I am trying to convert a job listing requisition into several job postings i.e.
Job_Req (Table)
Company_ID Job_Title No_of_Positions
1 Sales Clerk 12
I need to know what I need to use in my query to get this...
Job_Posting (Table)
Job_ID Company_ID Job_Title
1 1 Sales Clerk
2 1 Sales Clerk
3 1 Sales Clerk
4 1 Sales Clerk
5 1 Sales Clerk
6 1 Sales Clerk
7 1 Sales Clerk
8 1 Sales Clerk
9 1 Sales Clerk
10 1 Sales Clerk
11 1 Sales Clerk
12 1 Sales Clerk
Any help would be appreciated.
Thanks