Thanks, I knew I could. Anything is possible. Right?
Jan ----- Original Message ----- From: "Stephen Markson" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, March 16, 2005 8:45 PM Subject: [RBG7-L] - RE: Splitting Table > 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 > >
