In SQL, is there a way to do union between two tables such that the results are filtered by a common condition between the two tables?

Basically I want to do this...

```
SELECT City, Country FROM Customers
UNION ALL
SELECT City, Country FROM Suppliers
WHERE Customers.Country = Suppliers.Country

```

Including some sample data...

```
Customers
City       Country
Alb        USA
Alb        UK
NY         Russia

Suppliers
City       Country
LA         USA
DesMoines  UK
NY         USA

```

And I would want to return the record from Customer that has a City designation of Alb - plus the records from Supplier that have the same Country designation that is the same as the record from Customer that has a City designation of Alb.

Now that I've looked at it for a bit - I see that I need to do a nested SQL statement...

```
Select * from Supplier
Where Country =
    (Select Country from Customer Where City = 'Alb')  

```

Sorry for the confusion everyone - I just needed to think about it for a minute.