View Single Post
Old Sep 8, 2004 | 10:58 AM
  #4  
Jim Galbally's Avatar
Jim Galbally
20K+ Super Poster.
 
Joined: May 2003
Posts: 20,599
Likes: 0
From: Ramsgate, Kent Drives: E39 530D Touring
Default

its some labelling program...

just foudna section in the enterprise manager called VIEWS and it could be what im after... but i just saved a view n it didnt appear in my program

here's my view statement:


Code:
CREATE VIEW dbo.Jimtest
AS
SELECT     dbo.StyleColourSizeSellingCodes.Item_Code, dbo.StyleColourSizeSellingCodes.ID, dbo.StyleColourSizeProducts.Style, 
                      dbo.StyleColourSizeProducts.Colour, dbo.StyleColourSizeProducts.SizeX
FROM         dbo.StyleColourSizeProducts INNER JOIN
                      dbo.StyleColourSizeSellingCodes ON dbo.StyleColourSizeProducts.ID = dbo.StyleColourSizeSellingCodes.Item_Code
here's the program 9that comes with NO help file

Reply