Hi everyone.

I have this situation:

tbl_A ( Suppliers ):

Code:
IDSUP	SUP	
1	MULTI
2	SUPER
3	DEVEL
...
tbl_B ( Delivery)

Code:
ID	IDSUP	SUP	DATE_DELIVERY
1	1	MULTI	2008-04-29
2	2	SUPER	2008-04-29
3	3	DEVEL	2008-04-29
4	1	MULTI	2008-04-30
5	3	DEVEL	2008-04-30
6	1	MULTI	2008-05-02
7	2	SUPER	2008-05-02
I execute this query SQL:

Code:
SELECT A.IDSUP, A.SUP, B.DATE_DELIVERY
FROM tbl_A A
LEFT JOIN tbl_B B
ON B.IDSUP = A.IDSUP
WHERE B.DATE_DELIVERY = '2008-05-02'
But I don't have this output:

Code:
IDSUP	SUP	DATE_DELIVERY
1	MULTI	2008-05-02
2	SUPER	2008-05-02
3	DEVEL	NULL

Can you help me?
Thamks, regards
Viki