I think that this will work:
$query = "SELECT page.*, url.* FROM `page` LEFT JOIN `keywords` USING
(`page_id`) LEFT JOIN URL USING (`page_id`) WHERE MATCH
(`keywords`.`keyword_txt`) AGAINST ('$keyword'
IN BOOLEAN MODE)";
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"leegold" <[EMAIL PROTECTED]> wrote on 10/08/2004 12:06:17 PM:
> A popular question, how to select/query from two tables. I googled it
> but am having trouble, wondered if anyone would answer this newbie
> question. Here's my existing (PHP) query:
>
> $query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING
> (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$keyword'
> IN BOOLEAN MODE)";
>
> I want to SELECT from a new second table using "page_id" just like I'm
> doing now...they all are related by that page_id field. So i'm already
> selecting from a table called "page" and I want to select from a new
> table called "url" the same i do for "page" at the same time. How do I
> modifiy my statement?
>
> Thank you sincerely,
> Lee G.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
