>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.
>
>skc
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
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
Re: DBMS and lisp, etc. ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database.... (eq (order-customer orderA) ... (comp.lang.lisp)
Re: Populating a list -- table structure? ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ...KitID, long integer ... (microsoft.public.access.forms)
Re: Populating a list -- table structure? ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ...Queries (just shows the QBE grid for convenience -- ... (microsoft.public.access.forms)
Re: Populating a list -- learning Access ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL!... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ...Queries (just shows the QBE grid for convenience -- ... (microsoft.public.access.forms)
