Isabel You'll need to tell us some more about the view collapsed_by_email before we can diagnose the problem. How does it relate to the tables in the query that works? Regards Nigel ----- Original Message ---- From: Isabel Bedoya <isabel_bga@xxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Wednesday, December 12, 2007 5:12:00 PM Subject: Weird results from query Hello all, I need an advise with the following query. While executing the query it displays the following results: <snip>