I have two tables...
Table1
Table2

Table1 fields...
Key
Value

Table2 fields...
Key
Value
Filter

Values for Table1...
-Key-
1
2
3
4

-Value-
Value1
Value2
Value3
Value4

Values for Table2...
-Key-
1
2
3

-Value-
Value1
Value2
Value3

-Filter-
1
0
0

How can I write a query which shows all Values in Table1, and filters all Values in Table2 where Filter = 1?

In other words, the result should be...
Value2
Value3
Value4

Thanks for any help,
Shep
(sorry about the formatting)

[This message has been edited by Shep (edited 04-15-2002).]

I think I have it, never mind.