"field cannot be bound" 1

[LeonAtRC]

Tbl_A
   fName
   fSex
   aKey

Tbl_B
   fHome
   fSex
   bKey

These two tables are inner joined on the aKey and bKey in a view (theVue) that outputs these fields:
Tbl_A.fName, Tbl_A.Sex, Tbl_B.fHome
(The keys and tbl_B.Sex are not included in the view.)

The query is:

SELECT * FROM theVue ORDER BY tbl_A.Sex

The error is:

The multi-part identifier "Tbl_A.sex" could not be bound.

When I DON'T qualify the orderby field:

SELECT * FROM theVue ORDER BY Sex

the query will run.

My question is why?

If I can't find an easy answer I have a lot of "un-qualifying" to do!

 

[markros]

The view doesn't store original table with it. When you select from a view, the only 'table/alias' you can reference is theVue.

So, ORDER BY theVue.Sex will work. But references to the tables that produced the view will not.

PluralSight Learning Library

 

[LeonAtRC]

Thanks markos.
In 12 years I've never come across that!