Hey folks. I have been formulating SQL queries to the point of my
brain turning to tapioca today. I have a simple query or at least it
seems simple enough.. Two tables...

TMP
count - mailing_id
20 10
30 11
.....

LISTS
mailing_id name
10 list 10
11 list 11


I simply need to for every record in TMP match the name from LISTS so
that the results look like this...

count mailing_id name
20 10 list 10


I think my brain has just given out because this is a remarkably
simple query I know.