the shema return by the new query differ from the base query

Posted by sochandara on Stack Overflow See other posts from Stack Overflow or by sochandara
Published on 2010-03-25T10:06:41Z Indexed on 2010/03/25 10:13 UTC
Read the original article Hit count: 236

Filed under:

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"

© Stack Overflow or respective owner

Related posts about vb.net