[RESOLVED] Query Help

Given the following two tables:

Table 1

col1 col2
1 6
2 7
3 5
3 5
2 4
2 6
4 3

AND

Table 2

col1 col2
1 AAA
2 BBB
3 CCC
4 DDD
5 EEE

I need a query that will result in Table2.col2 where I know Table1.Col1 [given that Table1.Col2 == Table2.Col1]

Make sense?

This sounds like a simple join, e.g.,

SELECT Table2.col2 FROM Table2, Table1 WHERE Table2.col1=Table1.col2 AND Table1.col1=:value

beauty - the only issue is that I only need each result returned once - so instead of getting:

6
6
5
4
4
4
3

I want:

6
5
4
3

Hint: DISTINCT.

beautious - thanks

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.

I love this forum. Indeed!