The Schema returned by the new query differ from the base query
- by sochandara
I am working on class project which required to work with Windows Application and this issue occurred to me that i don understand how to solved it can anybody help please?
I want to show the NATIONALITYNAME instead of showing NATIONALITYID in the grid view
SELECT COACH.COACHID, COACH.COACHFIRSTNAME, COACH.COACHLASTNAME, NATIONALITY.NATIONALITY
FROM COACH INNER JOIN
NATIONALITY ON COACH.NATIONALITYID = NATIONALITY.NATIONALITYID
Error Message: "The Schema returned by the new query differ from the base query"![alt text][1]