Discussion :

[MinsK]

Salut a tous,

J'ai cree une requete assez grosse et complexe dont l'une des colonnes est le resultats d'une sous-requete.
Maintenant j'aimerais filtrer les resultats de ma requete en creant une condition sur le resultat de ma sous-requete.
Voici un example se rapprochant de ma requete actuelle:

Code :

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
SELECT
      --Sous-Requete1
      (SELECT T_CUST.fld_name
	FROM tbl_customer AS T_CUST
	WHERE T2.cal_customer_id = T_CUST.fld_id
      ) AS cust_name,
      --Latest Date
      (SELECT T_ORDER.fld_event_date AS date1
	FROM (SELECT fld_epc_orders_payments_id AS order_id, MAX(fld_id) AS ids
		FROM tbl_epc_orders_payments_history_list
		WHERE fld_status = 'Invoiced'
		GROUP BY order_id) AS t3,
	    tbl_epc_orders_payments_history_list AS T_ORDER
	WHERE t3.ids = T_ORDER.fld_id AND T_ORDER.fld_epc_orders_payments_id = T_STAGE.fld_id
	AND T_ORDER.fld_status = 'Invoiced'
       ) AS latest_date
FROM
      tbl_epc_orders_payments AS T1,
      tbl_epc_orders AS T2
WHERE
      T1.fld_epc_orders_id = T2.fld_id AND T1.fld_status ='Invoiced'
AND latest_date BETWEEN '2009-05-22' AND '2009-11-22'

Cette requete va retourner l'erreur suivante:

ERROR: column "latest_date" does not exist

Comment faire pour filtrer sur "latest_date"?