DataGrid binding... small problem... help please

[Learning SQL Server]

Sorry if Im wrong, but couldnt you accomplish the same thing with a JOIN?

SELECT
M.SSN as 'SSNfromTableM',
M.LastName,
P.SSN as 'SSNfromTableP'
FROM Person P
INNER JOIN Midn M
ON M.SSN = P.SSN

Even so, assigning aliases to the columns with the same name should take
care of your problem...


"Steven" <stevenzilberman@alum.rpi.edu> wrote in message
news:0f7e01c35ce7$66916030$a101280a@phx.gbl...

> Hi. I have an SQL query which is something like this:
>
> SELECT M.SSN, M.lastName, P.SSN FROM Person P, Midn M
> WHERE M.SSN = P.SSN
>
> In the datagrid, if I wanted to output the SSN this does
> not work:
> <asp:BoundColumn HeaderText="Social" DataField="SSN" />
>
> It says that SSN does not exist, but last name works.
>
> I tried:
> <asp:BoundColumn HeaderText="Social" DataField="P.SSN" />
>
> and:
> <asp:BoundColumn HeaderText="Social" DataField="M.SSN" />
>
> What will work? I actually need it to enter the new data
> with something like newRow["SSN"]=... but is says that SSN
> does not exist. Thank you so much.
>
> Steven

[Steven]

I need that join to be there. I know that the fields have
the same name, which is why I named the tables P and M, so
I could call one field P.SSN and the other one M.SSN. I
just need to be able to output one. How can I do that?
Thank you.

>-----Original Message-----
>That's because you are selecting 2 fields named SSN.

Though presumably they

>should be the same, since you are joining on it. You

might as well take the

>second one out.
>
>"Steven" <stevenzilberman@alum.rpi.edu> wrote in message
>news:0f7e01c35ce7$66916030$a101280a@phx.gbl...

>> Hi. I have an SQL query which is something like this:
>>
>> SELECT M.SSN, M.lastName, P.SSN FROM Person P, Midn M
>> WHERE M.SSN = P.SSN
>>
>> In the datagrid, if I wanted to output the SSN this does
>> not work:
>> <asp:BoundColumn HeaderText="Social" DataField="SSN" />
>>
>> It says that SSN does not exist, but last name works.
>>
>> I tried:
>> <asp:BoundColumn HeaderText="Social"

DataField="P.SSN" />

>>
>> and:
>> <asp:BoundColumn HeaderText="Social"

DataField="M.SSN" />

>>
>> What will work? I actually need it to enter the new

data

>> with something like newRow["SSN"]=... but is says that

SSN

>> does not exist. Thank you so much.
>>
>> Steven

>
>
>.
>

[Marina]

I didn't say to get rid of the join. I said to get rid of the redundant SSN
column in your select statement.

Since P.SSN and M.SSN are the same because of your where clause - why select
both columns?

If this is still not clear, I'm talking about a SQL statement like:
SELECT M.SSN, M.lastName FROM Person P, Midn M
WHERE M.SSN = P.SSN


"Steven" <stevenzilberman@alum.rpi.edu> wrote in message
news:098d01c35cea$331ac180$a601280a@phx.gbl...

> I need that join to be there. I know that the fields have
> the same name, which is why I named the tables P and M, so
> I could call one field P.SSN and the other one M.SSN. I
> just need to be able to output one. How can I do that?
> Thank you.

> >-----Original Message-----
> >That's because you are selecting 2 fields named SSN.

> Though presumably they

> >should be the same, since you are joining on it. You

> might as well take the

> >second one out.
> >
> >"Steven" <stevenzilberman@alum.rpi.edu> wrote in message
> >news:0f7e01c35ce7$66916030$a101280a@phx.gbl...

> >> Hi. I have an SQL query which is something like this:
> >>
> >> SELECT M.SSN, M.lastName, P.SSN FROM Person P, Midn M
> >> WHERE M.SSN = P.SSN
> >>
> >> In the datagrid, if I wanted to output the SSN this does
> >> not work:
> >> <asp:BoundColumn HeaderText="Social" DataField="SSN" />
> >>
> >> It says that SSN does not exist, but last name works.
> >>
> >> I tried:
> >> <asp:BoundColumn HeaderText="Social"

> DataField="P.SSN" />

> >>
> >> and:
> >> <asp:BoundColumn HeaderText="Social"

> DataField="M.SSN" />

> >>
> >> What will work? I actually need it to enter the new

> data

> >> with something like newRow["SSN"]=... but is says that

> SSN

> >> does not exist. Thank you so much.
> >>
> >> Steven

> >
> >
> >.
> >

[Jeff Adkins]

Create an alias for each.

select m.ssn as m_ssn
, m.lastname as m_lastname
, p.ssn as p_ssn
from table1 M inner join table2 P on m.ssn = p.ssn

Using the inner join will improve performance.

Jeff

>-----Original Message-----
>I need that join to be there. I know that the fields

have

>the same name, which is why I named the tables P and M,

so

>I could call one field P.SSN and the other one M.SSN. I
>just need to be able to output one. How can I do that?
>Thank you.

>>-----Original Message-----
>>That's because you are selecting 2 fields named SSN.

>Though presumably they

>>should be the same, since you are joining on it. You

>might as well take the

>>second one out.
>>
>>"Steven" <stevenzilberman@alum.rpi.edu> wrote in message
>>news:0f7e01c35ce7$66916030$a101280a@phx.gbl...

>>> Hi. I have an SQL query which is something like this:
>>>
>>> SELECT M.SSN, M.lastName, P.SSN FROM Person P, Midn M
>>> WHERE M.SSN = P.SSN
>>>
>>> In the datagrid, if I wanted to output the SSN this

does

>>> not work:
>>> <asp:BoundColumn HeaderText="Social" DataField="SSN" />
>>>
>>> It says that SSN does not exist, but last name works.
>>>
>>> I tried:
>>> <asp:BoundColumn HeaderText="Social"

>DataField="P.SSN" />

>>>
>>> and:
>>> <asp:BoundColumn HeaderText="Social"

>DataField="M.SSN" />

>>>
>>> What will work? I actually need it to enter the new

>data

>>> with something like newRow["SSN"]=... but is says that

>SSN

>>> does not exist. Thank you so much.
>>>
>>> Steven

>>
>>
>>.
>>

>.
>

[Steven]

I tried this, and it said that SSNfromTableM does not
exist. It did not like the as 'SSNfromTableM'
and 'SSNfromTableP' statements. It would work if I
renamed the database variables, but I have so much code to
go through, that it would not be worth it. Is there
another way? Why do you think the "as" statement not
working? Thank you.

>-----Original Message-----
>Sorry if Im wrong, but couldnt you accomplish the same

thing with a JOIN?

>
>SELECT
>M.SSN as 'SSNfromTableM',
>M.LastName,
>P.SSN as 'SSNfromTableP'
>FROM Person P
>INNER JOIN Midn M
>ON M.SSN = P.SSN
>
>Even so, assigning aliases to the columns with the same

name should take

>care of your problem...
>
>
>"Steven" <stevenzilberman@alum.rpi.edu> wrote in message
>news:0f7e01c35ce7$66916030$a101280a@phx.gbl...

>> Hi. I have an SQL query which is something like this:
>>
>> SELECT M.SSN, M.lastName, P.SSN FROM Person P, Midn M
>> WHERE M.SSN = P.SSN
>>
>> In the datagrid, if I wanted to output the SSN this does
>> not work:
>> <asp:BoundColumn HeaderText="Social" DataField="SSN" />
>>
>> It says that SSN does not exist, but last name works.
>>
>> I tried:
>> <asp:BoundColumn HeaderText="Social"

DataField="P.SSN" />

>>
>> and:
>> <asp:BoundColumn HeaderText="Social"

DataField="M.SSN" />

>>
>> What will work? I actually need it to enter the new

data

>> with something like newRow["SSN"]=... but is says that

SSN

>> does not exist. Thank you so much.
>>
>> Steven

>
>
>.
>