WHERE clause - selecting based on values held in a different table

[aldridge_p]

Apologies for the title, its fairly indescript.

Scenario

3 Tables and an SQL query.

Table 1 (Raw Data)
Field 1 - identifier key
Field 2 - Status (Data type = Text/Combo Box (Row Source = SELECT [CI - Status Values].Status FROM [CI - Status Values])
Field 3 - name
..and so on...

Table 2 (CI - Status Values)
Field 1 - Status (Data type = Text)

Table 3 (CI-SV Completed Values)


Field 1 - Completed Value (Data type = Text)

Objective:
Create an sql query to select all fields from [Raw Data] based on the values held in [CI-SV Coompleted Values].[Completed Value].

I know this is wrong, but my brain has turned to mush and can't for the life of me think where I am going wrong, any help would be appreciated:
SELECT [Raw data].*
FROM [Raw data]
WHERE ([Raw Data].[Status] = [CI-SV Completed Values].[Completed Value]
ORDER BY [Raw Data].[Name];

Many thanks in advance.

[pbaldy]

Try

SELECT [Raw data].*
FROM [Raw data] INNER JOIN [CI-SV Completed Values] ON [Raw Data].[Status] = [CI-SV Completed Values].[Completed Value]
ORDER BY [Raw Data].[Name];

[aldridge_p]

Worked a charm cheers Paul.

Pat

[pbaldy]

Happy to help Pat, and welcome to the site by the way!