Double INNER JOIN

QuestionsDouble INNER JOIN
Jose Luis asked 6 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 6 years ago

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

Your Answer

6 + 5 =

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 / 5. Vote count:

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

Let us improve this post!