hello, my problem is to show data located in 4 table and bind them.
I want to display my data as followings:
----------------------------------------------------------------------------------------------------------------------------------------------------
MATRICULE_FISCALE(table CLIENT) | NOM_STE | NOM_CLT_PHYSIQUE | PRENOM_CLT_PHYSIQUE | NOM_CLT_FORF | PRENOM_CLT_FORF | NUM_TEL1 | NUM_TEL2 | ADRESSE_PERSONEL | E_MAIL|
----------------------------------------------------------------------------------------------------------------------------------------------------
MATRICULE_FISCALE(table CLIENT) | NOM_STE | NOM_CLT_PHYSIQUE | PRENOM_CLT_PHYSIQUE | NOM_CLT_FORF | PRENOM_CLT_FORF | NUM_TEL1 | NUM_TEL2 | ADRESSE_PERSONEL | E_MAIL|
----------------------------------------------------------------------------------------------------------------------------------------------------
Banketeshvar NarayanPosted Nov 11, 2015, 1:01 PM
select C.MATRICULE_FISCALE, NOM_STE,NOM_CLT_PHYSIQUE, PRENOM_CLT_PHYSIQUE, NOM_CLT_FORF, PRENOM_CLT_FORF,
NUM_TEL1, NUM_TEL2 from [dbo].[CLIENT] C
inner join [dbo].[CLIENT_FORFAITAIRE] CF
on C.MATRICULE_FISCALE=CF.MATRICULE_FISCALE
inner join CLIENT_MORALE CM
on C.MATRICULE_FISCALE=CM.MATRICULE_FISCALE
inner join [CLIENT_PHYSIQUE] CP
on C.MATRICULE_FISCALE= CP.MATRICULE_FISCALE