Discussion :

[bractar]

Bonjour, j'ai cette requete

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT * 
FROM folders f, data_bank_info_debit_credit_auth d1, data_business_info d2, data_business_profile d3, data_equipment d4, data_merchant_site_inspection d5, data_owners_or_officers_info d6, data_payment_and_miscellaneous d7, data_rates_fees d8, data_sales_profile d9, data_trade_ref d10
WHERE d1.id_client = d2.id_client
AND d2.id_client = d3.id_client
AND d3.id_client = d4.id_client
AND d4.id_client = d5.id_client
AND d5.id_client = d6.id_client
AND d6.id_client = d7.id_client
AND d7.id_client = d8.id_client
AND d8.id_client = d9.id_client
AND d9.id_client = d10.id_client
AND d10.id_client = f.id_client
AND f.id_client =22

le problème est que certaines de ces tables n'ont pas l'enregistrement demandé (id_client n'existe pas). Comment faire, je ne peux pas le deviner à l'avance.
Merci d'avance

[Adjanakis]

Bonjour,

Il semblerait que le LEFT JOIN soit la solution

[bractar]

ok merci mais pourrais-tu me montrer l'exemple pour l'une des lignes de ma requête?
Merci

[Adjanakis]

Ca pourrait ressembler à ceci

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT * 
FROM data_bank_info_debit_credit_auth d1
    LEFT JOIN data_business_info d2 ON (d1.id_client = d2.id_client)
    LEFT JOIN data_business_profile d3 ON (d2.id_client = d3.id_client)
    LEFT JOIN data_equipment d4 ON (d3.id_client = d4.id_client)
    LEFT JOIN data_merchant_site_inspection d5 ON (d4.id_client = d5.id_client)
    LEFT JOIN data_owners_or_officers_info d6 ON (d5.id_client = d6.id_client)
    LEFT JOIN data_payment_and_miscellaneous d7 ON (d6.id_client = d7.id_client)
    LEFT JOIN data_rates_fees d8 ON (d7.id_client = d8.id_client)
    LEFT JOIN data_sales_profile d9 ON (d8.id_client = d9.id_client)
    LEFT JOIN data_trade_ref d10 ON (d9.id_client = d10.id_client)
    LEFT JOIN folders f  ON (d10.id_client = f.id_client)
WHERE f.id_client =22

[bractar]

J'ai repris ta requête mains sans succés

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT * 
FROM data_business_info d1
    LEFT JOIN data_bank_info_debit_credit_auth d2 ON (d1.id_client = d2.id_client)
    LEFT JOIN data_business_profile d3 ON (d2.id_client = d3.id_client)
    LEFT JOIN data_equipment d4 ON (d3.id_client = d4.id_client)
    LEFT JOIN data_merchant_site_inspection d5 ON (d4.id_client = d5.id_client)
    LEFT JOIN data_owners_or_officers_info d6 ON (d5.id_client = d6.id_client)
    LEFT JOIN data_payment_and_miscellaneous d7 ON (d6.id_client = d7.id_client)
    LEFT JOIN data_rates_fees d8 ON (d7.id_client = d8.id_client)
    LEFT JOIN data_sales_profile d9 ON (d8.id_client = d9.id_client)
    LEFT JOIN data_trade_ref d10 ON (d9.id_client = d10.id_client)
    LEFT JOIN folders f  ON (d10.id_client = f.id_client)
WHERE f.id_client =22

En fait, pour tester, l'id_client n'est dispo que dans la table data_business_info, celle que j'ai donc déclarée en d1 et mise au début de ma requête