oops! I hit SEND before I was done. (BAD FINGERS!)
SELECT *
FROM movies
LEFT JOIN director_movies
ON director_movies.movie_id=movies.id
LEFT JOIN director
ON director_movies.director_id = director.id
LEFT JOIN country_movies
ON country_movies.movie_id=movies.id
LEFT JOIN country
Peter Brawley <[EMAIL PROTECTED]> wrote on 02/12/2006 03:40:52
PM:
> Jessica,
>
> Your first query, with inner joins, fails with the error message
>
> Unknown column 'movies.id' in 'on clause
>
> because the query inside parentheses in ...
> ...
> FROM movies
> INNER JOIN (director INN
Oops, I meant to send this to the list so that all could benefit.
--
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jessica Yazbek" <[EMAIL PROTECTED]>
Sent: Sunday, February 12, 2006 4:19 PM
Subject: Re: Multiple many-to-many SELECT
Jessica,
Your first query, with inner joins, fails with the error message
Unknown column 'movies.id' in 'on clause
because the query inside parentheses in ...
...
FROM movies
INNER JOIN (director INNER JOIN director_movies
ON director_movies.director_id = director.id
AND director_mov
By request, here are the create statements for my tables:
movies | CREATE TABLE `movies` (
`id` int(11) NOT NULL default '0',
`catalog_description` text,
`title` text,
`website_url` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
director | CREATE TABLE `director` (
`i
convincingly
than I do ;-)
I have to dash but if you have followup questions, post them in
the list and
I, or someone else, will likely be able to answer.
--
Rhino
- Original Message -
From: "Jessica Yazbek" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 09, 200
eginning
>
> You may find that other people explain the idea more clearly or convincingly
> than I do ;-)
>
> I have to dash but if you have followup questions, post them in the list and
> I, or someone else, will likely be able to answer.
>
> --
> Rhino
>
>
> - O
Thursday, February 09, 2006 5:28 PM
Subject: Multiple many-to-many SELECT
Hello,
I apologize if this is a common question; I have been working with it
and googling for days, and can't seem to find anyone who has been
trying to do the same thing that I am. Maybe I'm using the wrong
k
Hello,
I apologize if this is a common question; I have been working with it
and googling for days, and can't seem to find anyone who has been
trying to do the same thing that I am. Maybe I'm using the wrong
keywords. In any event, I am desperate for help. Here is my problem:
I have a dat