Double INNER JOIN

QuestionsDouble INNER JOIN
Jose Luis asked 11 years ago

Hi!

I have a table with 3 fields

id
id_table1
id_table2

id is PK of table0
id_table1 is PK of table1 that have name_table1 field
id_table2 is PK of table2 that have centername_table2 field

I use a SELECT with INNER JOIN of id to show name_table1 and centername_table2

SELECT id, name_table1, centername_table2
INNER JOIN name_table1 on table1.id = id_table1
INNER JOIN centername_table2 on table2.id = id_table2

in phpmyadmin works fine …

But in phpgrip only show onces every type of name_table1 and centername_table2 and then all rows in blank

Can help me ?

1 Answers
Abu Ghufran answered 11 years ago

Please paste the complete code for review. You can use http://pastebin.com for sharing code.

Your Answer

20 + 20 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?