Re: SQL Statement

From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 19:54:47 GMT

SELECT TableA.FieldMany
FROM TableA INNER JOIN TableB ON TableA.FieldMany = TableB.FieldOne;

<anonymous@discussions.microsoft.com> wrote in message
news:5fe501c42de1$096e94b0$a101280a@phx.gbl...
> Please help!!!
>
> I am trying to write an SQL command that will display a
> all the data from table A and data from column 1 in table
> B.
>
> The two tables are linked in a one to many realtionship,
> with table A having multiple copies of data held in column
> 1 of Table B.
>
> Thanks
>
> Nick

Relevant Pages

  • Re: When is a NULL Not a NULL ?
    ... TableA INNER JOIN TableB ON TableA.ID = TableB.ID ... Note that those are two single quotes, ... there's little reason to do so. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Delete Query failure
    ... FROM TableA INNER JOIN TableB ... If you are using the query grid, UNCHECK Show for any fields that are in the ... >> from which the deletion is to take place. ...
    (microsoft.public.access.queries)
  • Re: Joining Tables on Similar, but not identical, Fields?
    ... With some limitations (such as the query not being updateable, ... FROM TableA INNER JOIN TableB ... This will find records where TableA contains "Seattle, ...
    (microsoft.public.access.queries)
  • Re: How to ignore fields in Update Query
    ... UPDATE TableA INNER JOIN TableB ON TableA.Number = TableB.Number ... > Did I set up my query wrong? ...
    (microsoft.public.access.queries)