Joining Question

Just a Quick Question..
I have a query that is similar to this
Select colA
, colB
, colC
, colB + colC as ColD
From myTable
Say I wanted to Join 'ColD' to 'myOtherTable' to a column called myOColA
Is that possible?
I'm not sure how to Reference ColD at all in a query..
I've having a problem searching the web for the correct terminology of what
ColD reprents.
www.krushradio.com - Internet Radio for the rest of usSelect *
from myOtherTable a INNER JOIN
(Select colA, ColD
, colB
, colC
, colB + colC as ColD
From myTable) b on a.ColumnFromMyOtherTable = bColD
"Daniel Regalia" <DanielRegalia@.discussions.microsoft.com> wrote in message
news:57B9E2D7-0E42-4F99-930C-E702E06F688C@.microsoft.com...
> Just a Quick Question..
> I have a query that is similar to this
> Select colA
> , colB
> , colC
> , colB + colC as ColD
> From myTable
> Say I wanted to Join 'ColD' to 'myOtherTable' to a column called myOColA
> Is that possible?
> I'm not sure how to Reference ColD at all in a query..
> I've having a problem searching the web for the correct terminology of
> what
> ColD reprents.
> --
> www.krushradio.com - Internet Radio for the rest of us|||Select b.colA
, b.colB
, b.colC
, b.colB + b.colC as myColD
, a.ColD
From myTable b
inner join myOtherTable a
on a.ColD = b.colB + b.colC
"Daniel Regalia" <DanielRegalia@.discussions.microsoft.com> wrote in message
news:57B9E2D7-0E42-4F99-930C-E702E06F688C@.microsoft.com...
> Just a Quick Question..
> I have a query that is similar to this
> Select colA
> , colB
> , colC
> , colB + colC as ColD
> From myTable
> Say I wanted to Join 'ColD' to 'myOtherTable' to a column called myOColA
> Is that possible?
> I'm not sure how to Reference ColD at all in a query..
> I've having a problem searching the web for the correct terminology of
what
> ColD reprents.
> --
> www.krushradio.com - Internet Radio for the rest of us|||Jim,
The one I wanted to join was (taken from your example) 'myColD' on a
different table.
--
www.krushradio.com - Internet Radio for the rest of us
"Jim Underwood" wrote:

> Select b.colA
> , b.colB
> , b.colC
> , b.colB + b.colC as myColD
> , a.ColD
> From myTable b
> inner join myOtherTable a
> on a.ColD = b.colB + b.colC
> "Daniel Regalia" <DanielRegalia@.discussions.microsoft.com> wrote in messag
e
> news:57B9E2D7-0E42-4F99-930C-E702E06F688C@.microsoft.com...
> what
>
>|||MyColID is in the other table (myOtherTable)
ColB and ColC are in the first table (myTable )
"Daniel Regalia" <DanielRegalia@.discussions.microsoft.com> wrote in message
news:6C18C431-032C-4761-9B08-607797BF0B05@.microsoft.com...
> Jim,
> The one I wanted to join was (taken from your example) 'myColD' on a
> different table.
> --
> www.krushradio.com - Internet Radio for the rest of us
>
> "Jim Underwood" wrote:
>
message
myOColA