Help with JOIN

[dbk]

Hi

 

I need some help with a query that don't work:

 

SELECT * FROM contact JOIN project_contact USING (contact_id) WHERE project_id = 1301

 

I have two tables - "contact" and "project_contact".

"contact" contains some information about people.

"project_contact" contains information about wich projects a contact is linked to.

 

Both tables has a column  "contact_id".

 

But the "project_contact" table has also a column "project_id" that I want to sort the contacts with!!!

 

If you understand the explanation what am I doing wrong?

[Psycho]

Well, you state you want to use the project_id to "sort" the records, but your query is currently filtering the records. Other than that, I see no obvious problems. Although, if there are other columsn with duplicate names between the tables that would cause an error. You don't state if you are getting any errors. If so, please post them.

 

If you really do want to sort instead of filter the query would look something like this:

SELECT *
FROM contact
JOIN project_contact USING (contact_id)
ORDER BY project_id

[dbk]

Hi mjdamato

 

Sorry for my english.. What I want is to filter using the "project_id" !

each contact can be linked to many projects and thats why I made the "project_contact" table that only contain a primary key with autoincrease, the contact_id and the project_id.

 

Hope it makes sense!

 

By the way.. I don't get any error using: SELECT * FROM contact JOIN project_contact USING (contact_id) WHERE project_id = 1301

The filter just don't work!!

 

[Psycho]

Well, I can't determine what is wrogn without seeing the data since the queery looks fine. Try posting the table structure for the two tables and provide a few sample records that are being returned from the query which you feel shouldn't be.

[dbk]

Hi mjdamato

 

I just found out that the error was in some other code (php).

The query returns the correct data!

 

As I once was told - ALLWAYS TRY THE QUERY IN CMD!!!

 

I'm very sorry for wasting your time!!