2. PHPRunner General questions
  3. Help !! multiple relationship
This topic is locked

Help !! multiple relationship

 		12/27/2007 00:24:44
PHPRunner General questions
U
 uzu1302 author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7130&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' /> Hello, Nobody to help me??
I created the third Table for relationship "fournisseur_marque" and 2 fields (Id_Num, Ma_Num)

Now my database is

Table "fournisseur" - Field (Id_Num, Id_Nom, Id_Adresse ...)

Table "marque" - Field (Ma_Num, Ma_Nom)

Table "fournisseur_marque" - Field (Id_Num, Ma_Num)
Where I use INNER JOIN?
Fournisseur_list - > Details found stand out - >: 0 marque_list - > supplier - > Details found: 0

How to post(show) details?
Thank you
J
 		Jane 12/28/2007

Hi,
have you set up master-detail relatioship on the Datasource tables tab?

To join two tables edit SQL query on the Edit SQL query tab.

Here is a sample:

select fournisseur_marque.Id_Num,

fournisseur_marque.Ma_Num,

fournisseur.Id_Adresse

from fournisseur inner join fournisseur_marque

on fournisseur.Id_Num=fournisseur_marque.Id_Num