I have been doing this...
SELECT tmp.count, tmp.mailing_id, lists.name
FROM
tmp, lists
WHERE
tmp.mailing_id = lists.mailing_id

I keep getting a zero result.


On Oct 2, 2:38 pm, worldcycl...@gmail.com wrote:
> 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.