how to remove repeate record when using join

I  have to two table  the first is

USE [Machinery] GO /****** Object: Table [CarAndbicycle].[CarAndbicycle] Script Date: 07/02/2013 11:10:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [CarAndbicycle].[CarAndbicycle]( [ID] [int] IDENTITY(1,1) NOT NULL, [CompanyNameID] [int] NULL, [CarNameID] [int] NULL, [CarAndbicycleTypeID] [int] NULL, [YearProduct] [int] NULL, [ShaciNumber] [nvarchar](50) NULL, [ColorID] [int] NULL, [FuelTypeID] [int] NULL, [EngineNumber] [nvarchar](50) NULL, [PanelNumberNew] [nvarchar](50) NULL, [PanelNumberOld] [nvarchar](50) NULL, [TaskTypeID] [int] NULL, [CarAndbicycleClassificationID] [int] NULL, [CarAndbicycleStatusID] [int] NULL, [InsuranceEndDate] [date] NULL, [LicenseEndDate] [date] NULL, [Note] [nvarchar](500) NULL, [UserID] [int] NULL, [DateEnter] [date] NULL, [isDelete] [bit] NULL, CONSTRAINT [PK_DrivenAndbicyc ...