Re: [PHP] Newbie LEFT JOIN question

Jackson Linux wrote: http://lists.mysql.com/ -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Newbie LEFT JOIN question

First, I apologize - I'm new to this, grateful for the list and just confused. I didn't mean to post improperly. Second, thanks so much Rory for simplifying it and answering that anyway. I promise I wasn't going for technical impressiveness and easier is definitely better! Thanks again, Jack

Re: [PHP] Newbie LEFT JOIN question

Jackson Linux wrote: Hi, all, I have three tables; 'cv', the main table, 'jobcat', a definition table and 'cvjobcats', an intersection table (for more detail see PS below). I'd like to join this all together to be able to make a headline consisting of the plain English description of the job ca

Re: [PHP] Newbie LEFT JOIN question

This is the P H P list not the S Q L list. I mean really, your question isn't even worded as a PHP question. Maybe if you add a few echos or a variable here and there someone here might let it pass. But just asking a plain old SQL question is not the purpose of the P H P list. Cheers, Rob. On We

[PHP] Newbie LEFT JOIN question

Hi, all, I have three tables; 'cv', the main table, 'jobcat', a definition table and 'cvjobcats', an intersection table (for more detail see PS below). I'd like to join this all together to be able to make a headline consisting of the plain English description of the job category followed by a