Need help getting information from 2 tables at once

[M Eason]

I'm trying to access data from one table by matching ids pulled from another table. I can't quite get the syntax though if anybody could help I would appericate it.

Here is where I'm at

select * from table1 where variable 1 = (select distinct(variable 2) from table 2 where variable 3 = variable 4)

[Paul Asaro]

Not quite sure what you are tying to accomplish but this is valid syntax. If the join column is t1.variable1 to t2.variable2 and the where condition is t2.variable2 = t2.variable4 than this is correct.

Thanks,

Paulie

SELECT t1.*
FROM table1 as t1
JOIN
table2 as t2 ON t1.variable1 = t2.variable2
WHERE t2.variable2 = t2.variable4

[Juergen Leis]

Another way (eliminating duplicate rows) could be

select * from table1 where variable1
IN
(select distinct(variable2) from table2 where variable3 = variable4)



------------
Paul Asaro at 1/4/2002 10:41:01 AM

Not quite sure what you are tying to accomplish but this is valid syntax. If the join column is t1.variable1 to t2.variable2 and the where condition is t2.variable2 = t2.variable4 than this is correct.

Thanks,

Paulie

SELECT t1.*
FROM table1 as t1
JOIN
table2 as t2 ON t1.variable1 = t2.variable2
WHERE t2.variable2 = t2.variable4