CREATE VIEW ThisView (JobID, JobNote) AS + SELECT JobID, Note1 FROM ThatTable UNION ALL + SELECT JobID, Note2 FROM ThatTable UNION ALL + SELECT JobID, Note3 FROM ThatTable UNION ALL + SELECT JobID, Note4 FROM ThatTable UNION ALL + SELECT JobID, Note5 FROM ThatTable
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 482 2140 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Johansen > Sent: March 16, 2005 2:02 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Splitting Table > > This is a long shot, but here goes. > > I have a table with a number of columns but I am only going to concern my > self with 6 for now. Kind of laid out like this; > > JobID Note1 Note2 Note3 Note4 Note5 > ------- -------- -------- -------- -------- > -------- > 273 This is a test > OK > > The goal is change this into a one to many relationship where I would have a > table as such; > > JobID Note > ------- ------- > 273 This > 273 is > 273 a > 273 test > 273 OK > > I've done what I want with some code but was wondering if anyone had tried > to do anything like this with a view. > > Jan
