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.

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.