Query to Find Not Matching Columns in Two Tables

Databases
1

Ok,

here is what I have


$getmismatch = mysql_query("SELECT films.film_id,films.film_title,films.aus
 FROM films,film_matching 
WHERE films.film_id=film_matching.film_id 
AND 
films.aus!=film_matching.aus",$connect);

I have two tables.

I want only the rows with matching “film_id” columns that don’t also have matching “aus” columns.

What am I doing wrong here?

Thanks
Ryan

2

that query looks exactly right for what you said you wanted

:slight_smile:

3

That’s what I thought, but I’m getting:

mysql_query() expects parameter 2 to be resource, null given

Cheers
Ryan

4

sonds to me like you have a php problem :slight_smile:

5

Ah, you are right. I forgot to include my connection script.

But I am getting zero rows showing up, and I’ve tried changing a variable in the “aus” column of one table to ensure that it is different from matching column in other table for the same “film_id”.

So I’ll have

Table “films”
film_id = 3200
aus = R

Table “film_matching”
film_id = 3200
aus = S

So I want that row to show up in my query, as the AUS is not the same for same film_id.

Possible?
Ryan

6

Cancel that!

I forgot to update other table with recent inserts.

(smack head)

It’s working

Ryan

7

glad i could help :smiley: