Issue with formating SQL and WITH statement
I'm having issue with formating WITH subquery.
Here a simple exemple I have create:
- WITH client AS (SELECT r.id_region, r.num_region, r.pays FROM region r INNER JOIN pays p ON r.id_region = p.id_region)
SELECT cl.id_client
,cl.client_nom
,cl.client_adresse
,co.num_commande
FROM client cl
INNER JOIN COMMANDE co ON cl.id_client = co.id_client
WHERE cl.id_client = @ID_CLIENT
ORDER BY co.DATE_COMMANDE;
I whould like to be able to have this kind of result:
- WITH client AS (SELECT r.id_region
,r.num_region
,r.pays
,p.num_pays
,r.code_postal
,r.num_tournee
FROM region r
INNER JOIN pays p ON r.id_region = p.id_region
INNER JOIN DEPARTEMENT d ON d.id_region = r.id_region)
SELECT cl.id_client
,cl.client_nom
,cl.client_adresse
,co.num_commande
FROM client cl
INNER JOIN COMMANDE co ON cl.id_client = co.id_client
WHERE cl.id_client = @ID_CLIENT
ORDER BY co.DATE_COMMANDE;
I tried different configuration but I never succed to have this result.
I have put in attachement my formating profile