Help for newbie please
Help for newbie please
(OP)
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
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
Talk To Other Members
RE: Help for newbie please
FROM Table1 INNER JOIN Table2 ON Table1.ObjectID = Table2.ObjectID
WHERE Table1.Type = 'Defect'
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?