Query...

From: jpatton (jppatton_at_vt.edu)
Date: 05/28/04 

Date: Fri, 28 May 2004 08:33:17 -0400

This is fairly straightforward but it is just one of those things...

If I query a database like so (this was pulled from the code and modified a
little of course):

SELECT ITEM1, STRING(REPEAT(0, 20 - LENGTH(T1.ITEM2)), REPLACE(T1.ITEM2,
'-', '')),
FROM TABLE1 T1 JOIN TABLE2 T2 ON T1.BLAH = T2.BLAH
WHERE ITEM2 = (SELECT SOME VALUE)

What I am curious about is in my WHERE clause do I:

#1. Need to repeat the formatting (methods) around T1.ITEM2?
#2. Can I refer to it as I am, just ITEM2 or do I need to specify T1.ITEM2
or use an AS clause?

Thanks!

Relevant Pages

  • Re: cannot write to database query
    ... The select query is as shown below, I cannot change the information in the ... What are the SQL views of significant queries? ... What I failed to mention is that this database was fully functioning last ... It has a TRANSFORM clause. ...
    (microsoft.public.access.queries)
  • Re: what makes this query not updatable
    ... Then compact the database. ... It has a GROUP BY clause (totals query). ... It has a TRANSFORM clause. ... > why the more complex queries with employee details and contracts tables ...
    (microsoft.public.access.queries)
  • Re: Using a Select Query to build a MDB table from a Fox table
    ... MS Access has a 'make-table' query with IN clause you can specify ... As you said the IN <database> clause is specific to Access SQL. ...
    (microsoft.public.fox.helpwanted)
  • Re: cannot write to database query
    ... What I failed to mention is that this database was fully functioning last ... we would need to know more about your table structure and query. ... Access MVP Allen Browne has summarized the reasons: ... It has a TRANSFORM clause. ...
    (microsoft.public.access.queries)
  • Re: Questions on format of Select statement
    ... Access Help on the FROM clause, ... This argument can be a single table name, a saved query, or a compound ... type The name of the database type used to create table if a database is not a ... You can also use the DATABASE reserved word to specify the external database. ...
    (microsoft.public.access.queries)