Ok great, it worked with the inner join. Here is the full query.

Thanks again!

USE [navtables]

GO

/****** Object: StoredProcedure [dbo].[RS_OrderStock] Script Date: 03/12/2012 12:36:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Hello,

Thanks for this!

Problem is that I have a inner join on number on another table. Can this solution still be applied?

haha no

yes this should work but column y would be repetetive, but maybe that cant be avoided?