Solved

The multi-part identifier "CourtesyCars.carreg" could not be bound.

Posted on 2006-07-05
4
315 Views
Last Modified: 2008-03-17
Hi

I have been working on trying to convert this query from Access to SQL Server for the past day and am still having trouble. Im almost there, but am still getting the following error message on the query below:

The multi-part identifier "CourtesyCars.carreg" could not be bound.

I can see why Im getting this, but cant seem to rectify it. Any ideas?

Cheers

SELECT     Repairs.repairs_ID, InsuranceCompanies.insurance_ID, OwnersCar.car_ID, OwnersCar.mobile AS custMobile, Repairs.stage,
                      Repairs.customerInformed, Repairs.finished, Repairs.courtesyCar_ID, Repairs.hirecar, CC_1.in_date, CC_1.out_date,
                      CarManafacturers.Manafacturer + ' ' + CarModels.Model AS Vehicle, OwnersCar.title + ' ' + OwnersCar.OwnerName AS Owner,
                      OwnersCar.CarReg AS Reg, Repairs.JobRefNo AS JobRef, CourtesyCars.carreg AS CC, Repairs.StartDate AS Start,
                      InsuranceCompanies.Name AS Provider, StatusCodes.Description AS Status, Repairs.EstFinishDate AS Finish, Repairs.HitCount AS [Hit count],
                      OwnersCar.claimnumber AS ClaimNo
FROM         Repairs INNER JOIN
                      InsuranceCompanies ON InsuranceCompanies.insurance_ID = Repairs.insurance_ID INNER JOIN
                      CarModels ON CarModels.make_id = Repairs.make_ID INNER JOIN
                      CarManafacturers ON CarManafacturers.Manafacturers_id = CarModels.Manafacturer_id INNER JOIN
                      StatusCodes ON StatusCodes.Status_ID = Repairs.stage INNER JOIN
                      OwnersCar ON OwnersCar.car_ID = Repairs.cars_ID INNER JOIN
                      colours ON OwnersCar.colour_id = colours.colour_id LEFT OUTER JOIN
                          (SELECT     cc.carreg, cch.ccar_history_id, cch.in_date, cch.out_date
                            FROM          CourtesyCars AS cc INNER JOIN
                                                   ccar_history AS cch ON cc.courtesyCar_ID = cch.ccar_id) AS CC_1 ON Repairs.courtesyCar_ID = CC_1.ccar_history_id LEFT OUTER JOIN
                      Operatives ON Repairs.Op_ID = Operatives.Op_Id
WHERE     (1 = 1) AND (Repairs.potential = 0) AND (Repairs.finished = 0) AND (Repairs.StartDate <= GETDATE())
0
Comment
Question by:digital_soul
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 125 total points
ID: 17041335
Hi digital_soul,

SELECT     Repairs.repairs_ID, InsuranceCompanies.insurance_ID, OwnersCar.car_ID, OwnersCar.mobile AS custMobile, Repairs.stage,
                      Repairs.customerInformed, Repairs.finished, Repairs.courtesyCar_ID, Repairs.hirecar, CC_1.in_date, CC_1.out_date,
                      CarManafacturers.Manafacturer + ' ' + CarModels.Model AS Vehicle, OwnersCar.title + ' ' + OwnersCar.OwnerName AS Owner,
                      OwnersCar.CarReg AS Reg, Repairs.JobRefNo AS JobRef, CourtesyCars.carreg AS CC, Repairs.StartDate AS Start,
                      InsuranceCompanies.Name AS Provider, StatusCodes.Description AS Status, Repairs.EstFinishDate AS Finish, Repairs.HitCount AS [Hit count],
                      OwnersCar.claimnumber AS ClaimNo
FROM         Repairs INNER JOIN
                      InsuranceCompanies ON InsuranceCompanies.insurance_ID = Repairs.insurance_ID INNER JOIN
                      CarModels ON CarModels.make_id = Repairs.make_ID INNER JOIN
                      CarManafacturers ON CarManafacturers.Manafacturers_id = CarModels.Manafacturer_id INNER JOIN
                      StatusCodes ON StatusCodes.Status_ID = Repairs.stage INNER JOIN
                      OwnersCar ON OwnersCar.car_ID = Repairs.cars_ID INNER JOIN
                      colours ON OwnersCar.colour_id = colours.colour_id LEFT OUTER JOIN
                          (SELECT     cc.carreg, cch.ccar_history_id, cch.in_date, cch.out_date
                            FROM          CourtesyCars AS cc INNER JOIN
                                                   ccar_history AS cch ON cc.courtesyCar_ID = cch.ccar_id) AS CC_1 ON Repairs.courtesyCar_ID = CC_1.ccar_history_id LEFT OUTER JOIN
                      Operatives ON Repairs.Op_ID = Operatives.Op_Id
WHERE     (1 = 1) AND (Repairs.potential = 0) AND (Repairs.finished = 0) AND (Repairs.StartDate <= GETDATE()) CourtesyCars

You had not aliased the joined pseudo-table

Tim Cottee
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17041353
digital_soul,
> CourtesyCars.carreg  
try by replacing the above with
                     CC_1.carreg
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Table where row act as column 11 70
SQL Job Hung 17 37
Access #Deleted data 20 43
MS Access Pasthru Query to Execute SQL Stored procedure 8 41
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question