| Help creating view for each record... [message #412962] |
Mon, 13 July 2009 12:07  |
rashowlist
Messages: 4
Registered: July 2009
|
Junior Member |
|
|
Hey all, I need some SQL help to create a view similar to below:
I have one table which contains employee titles:
101
102
103
104
I have another table which contains department descriptions:
Sales
Purchasing
Quality Control
I would like to create a view which provides:
101 Sales
101 Purchasing
101 Quality Control
102 Sales
102 Purchasing
102 Quality Control
103 Sales
103 Purchasing
103 Quality Control
104 Sales
104 Purchasing
104 Quality Control
Any help would be greatly appreciated.
Chuck
|
|
|
|
|
|
| Re: Help creating view for each record... [message #412965 is a reply to message #412963] |
Mon, 13 July 2009 12:22  |
rashowlist
Messages: 4
Registered: July 2009
|
Junior Member |
|
|
|
Not a homework assignment. I work for the CPD finance division and we were trying to figure out how to put together a table or view this way to get every combination of paytitles and certain codes (what we call caps codes) from our budget department. The data I provided in the example is just generic so it wouldn't be too difficult to explain.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
