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

Code:
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:

Code:
  
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