I went for the date solution although I really didn't favourite that 🙂 So by including a little WHERE clause the query is returning me the results I wanted.

Thanks everybody...

Hi guys, Tnx for the efforts.

Right now I get 2 users, namely Verbruggen and Hollewegens for car n° 2.

I don't want to see Verbruggen in that result. The date is...

In this case for car n° 2 I only want to see Hollewegens as being the current car user.

I need to do this without using the date or anything else.

Table 1:

USE [TEST]

GO

/****** Object: Table [dbo].[Cars] Script Date: 3/03/2016 13:27:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Cars](

[CarID] [int] NOT NULL,

[Make] [nvarchar](50) NULL,

[Model] [nvarchar](50) NULL,

CONSTRAINT [PK_Cars]...