I want to know how I can join one field of an INNER JOIN table in a SELECT QUERY.
Here's what i got so far: In this query my result would be NameA, NameB and idC, but i want to join tableA and tableC reference as shown in the image schema.
SELECT table_A.idC, table_A.nameA, table_B.nameB FROM table_Ref INNER JOIN table_A ON table_Ref.idA=tableA.idA INNER JOIN table_B ON table_Ref.idB=tableB.idB;
My wanted result would be nameA,NameB, and NameC using the idC field in table_A to know which nameC belongs to that idC.
I hope you can help me or give me a reference of this topic :)!