select x as y Recordset Problem

[nzgirl]

Hi....
I create a Recordset with a "select, a.x, b.x as y from table1 a join table2 b on a.c = b.c"
then I want to display both x and y
but although response.write(rs.fields("x&quot) works fine
response.write(rs.fields("y&quot) doesn't.

any pointers?
Thanks

 

[SonOfEmidec1100]

Should work except select, probably a typo as this would cause the query to fail.

maybe b.x contains a null ?

 

[nzgirl]

Thanks for the feedback!
select, is a mistype I do mean select
I've tried the query in query analyser and it runs fine....
But 1) I'm not sure how to view the results of a recordset except field by field and 2) I think the AS part might not do what I'm expecting...
I wasn't sure whether to put this in the ASP or SQL forum :-(

 

[SonOfEmidec1100]

I dont know about the asp but the sql looks correct and if you were using VB thats how you would refer to the returned field. Technically you should use rs.fields.item("y&quot

The AS basically names the returned field y instead of the field name within the table.