Peter,
Thank you very much for your reply. Three weeks later I am realizing that
the 'NOT IN' solution I had above does not work after all. Accordingly, I
went back and looked at your solution and it is close but it only gives
NULL results I am looking for something that excludes challenges that
Cheers.
AB
-Original Message-
From: Richard Reina [mailto:gatorre...@gmail.com]
Sent: Saturday, 26 September 2015 1:09 AM
To: peter.braw...@earthlink.net
Cc: mysql@lists.mysql.com
Subject: Re: Trouble with LEFT JOIN
Peter,
Thank you very much for your reply. Three weeks later I am
I have the following two tables;
mysql> select * from challenge;
+++-++--+-+--+
| ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID |
+++-++--+-+--+
| 1 | 1 |
On 2015-09-04 9:40 AM, Richard Reina wrote:
I have the following two tables;
mysql> select * from challenge;
+++-++--+-+--+
| ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID |
2015-09-04 11:18 GMT-05:00 Peter Brawley :
> On 2015-09-04 9:40 AM, Richard Reina wrote:
>
>> I have the following two tables;
>>
>> mysql> select * from challenge;
>> +++-++--+-+--+
>> | ID | PLR_ID |
On 2015-09-04 11:39 AM, Richard Reina wrote:
2015-09-04 11:18 GMT-05:00 Peter Brawley >:
On 2015-09-04 9:40 AM, Richard Reina wrote:
I have the following two tables;
mysql> select * from challenge;