sql server mseq: Question... -- sql server mseq

Question...

Skc
12/6/2005 4:09:02 AM

sql server mseq:

I want to do a "As" query in SQL. In Access, Query Designer, you can
specifiy in the criteria field something like:

Field name: From: DT_RDG_TO (so my field is called from)

[Reading Cons Detail - CU04TB36]![DT_RDG_TO]-[reading header -
cu04tb12]![qy_days_used]

How do I do this in SQL 2000? I have added necessary tables into a View but
cannot do the above.

Please help.

Re: Question...

Hugo Kornelis
12/6/2005 10:51:08 PM

[quoted text, click to view]

Hi skc,

I don't know what an "As" query is and I have not enough experience with
Access to understand your description.

In SQL Server, AS is a keyword that you can use to give a column or an
expression a new name. For instance:

SELECT Sales, Tax, (Sales - Tax) AS Net
FROM YourTable

If that's not what you mean, then please elaborate.

Best, Hugo
--