you could do its as stored procedure also which is exactly as it sounds - a bit of sql stored to be run anytime.
Code:
CREATE Procedure
yourspname
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
you can then just call the sp from your app
