Access XP SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can anyone help me with a select statement pls:
I have two tables with following fields and am tring to pick up the support
area field to appear in the CSDF 1 field, where system ID = machine id....

MD Table (Machine ID, CSDF 1)
Caller Mapping Table (System ID, Support Area)
 
I'm not 100% sure I understand what you want. It may just be a terminology
problem, but you used the phrase "select statement", which implies a SELECT
query. Yet you stated you wanted the [Support Area] field to appear in the
[CSDF 1] field, which implies an UPDATE query.

This is a simple SELECT query:
SELECT [Support Area] FROM [Caller Mapping Table]
INNER JOIN [MD Table]
ON [MD Table].[Machine ID] = [Caller Mapping Table].[System ID]

This is an UPDATE query to update the [CSDF 1] field with the value found in
the [Support Area] field:
UPDATE [Caller Mapping Table]
INNER JOIN [MD Table]
ON [Caller Mapping Table].[System ID] = [MD Table].[Machine ID]
SET [MD Table].[CSDF 1] = [Caller Mapping Table].[Support Area]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top