Relational lookups

From: Ike (rxv_at_hotmail.com)
Date: 10/17/03 

Date: Fri, 17 Oct 2003 15:18:37 GMT

I'm wondering how the following common scenerio is typically handled:

Suppose I have a table (tableA) where one of the fields ("the_field") is an
integer which is the key to another table (tableB).

I run a SELECT query on tableA, displaying, say, n results in tabular
format.

In this tabular format, "the_field" is showing as an integer, which,
essentially is meaningless to the user viewing the output.

Is there some mechanism I might use to convert these integer fields to a
value in tableB for purposes of this display WITHOUT having to run a query
on every line I am displaying?

Thanks, Ike

Relevant Pages

  • Re: Relational lookups
    ... > integer which is the key to another table (tableB). ... > I run a SELECT query on tableA, displaying, say, n results in tabular ...
    (comp.lang.java.databases)
  • Re: IF THEN in query..Maybe IIf
    ... assuming that there is a primary key for the existing records in the data ... table, which i'll call TableA, that matches a primary key in the imported ... now turn the query into an Update query. ... if the data file has the person's home ...
    (microsoft.public.access.queries)
  • Re: Limit numbers in primary key
    ... autonumber field per table. ... the same properties as the corresponding field in TableA. ... Add a field or whatever your primary key field is and set it as ... Create a Query. ...
    (microsoft.public.access.gettingstarted)
  • Re: Advanced query issue
    ... and then write a query linking just by your new ... FROM tablea As a RIGHT JOIN tableb as b ... That assumes tableb has all the possible occurrence of the two ... I also used UNION ALL, ...
    (microsoft.public.access.queries)
  • RE: filter for values in another table
    ... The other way is to use the IN Clause in your SQL statement. ... SELECT TableA.* ... WHERE TableA.ID NOT IN (SELECT DISTINCT ID FROM TableB)" ... runs is to create a query that some people call a "frustrated outer join". ...
    (microsoft.public.access.queries)