Help for newbie please 1

[SomersetBoy]

Hello
I am trying to write a simple sql query but cannot get it to work.
I have two tables-
Table 1 Table 2
ObjectID ObjectID
Type Name
Data

The result of the query should contain Table1.Data and Table2.Name
WHERE Table1.Type=Defect and the 2 objectID are the same

TIA

Graham

 

[PHV]

SELECT Table1.Data, Table2.Name
FROM Table1 INNER JOIN Table2 ON Table1.ObjectID = Table2.ObjectID
WHERE Table1.Type = 'Defect'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886