Re: Trouble with LEFT JOIN

2015-09-25 Thread Richard Reina
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

RE: Trouble with LEFT JOIN

2015-09-25 Thread Adrian Beech
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

Re: Trouble with LEFT JOIN

2015-09-04 Thread 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 | ACC_TYPE_ID | season | year | CHAR_ID |

Re: Trouble with LEFT JOIN

2015-09-04 Thread Richard Reina
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 |

Re: Trouble with LEFT JOIN

2015-09-04 Thread Peter Brawley
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;