View not working, select working

[mr.pita]

When I run this, I get an empty set of results back (no errors though):

drop view if exists wrentals;

create view wrentals as
select c.CustName from customer as c
join transactions as t on t.MemberID=c.MemberID
group by c.CustName;

But if I run just the select part from above, it works fine, and I actually get the results I'm looking for:

  
select c.CustName from customer as c
join transactions as t on t.MemberID=c.MemberID
group by c.CustName;

What can cause this? Using MySQL 5.1

[PHPycho]

select c.CustName from customer as c
join transactions as t on t.MemberID=c.MemberID
group by c.CustName;

is this query giving some results?

why don't you use specific join (join simply means INNER JOIN)?
Before posting please do format your code with proper wrapping.
formatted mysql code:

SELECT 
	c.CustName 
FROM 
	customer AS c
	INNER JOIN transactions AS t ON t.MemberID = c.MemberID
GROUP BY 
	c.CustName;

[guido2004]

Maybe I misunderstand your question, but the creation of a view doesn't return any result set, or does it?

[SirAdrian]

Maybe I misunderstand your question, but the creation of a view doesn't return any result set, or does it?

Doesn't.

[mr.pita]

Not sure what I did differently but all of a sudden it works.
Thanks everyone!

[r937]

that's called the "aoas" effect

post a question on a forum, and all of a sudden it works again