On Tue, 22 Aug 2006, Brian Cox wrote:
> Given a view like:
>
> create view view1 as
> select g.id as UserGroupId, s.uid as UserId, s.time as StartTime from stats
> s join groups g on g.uid = s.uid
>
> and a SELECT like:
>
> select a.UserGroupId,b.UserGroupId from view1 a
> full outer join vi
Given a view like: create view view1 as select g.id as UserGroupId, s.uid as UserId, s.time as StartTime from stats s join groups g on g.uid = s.uid and a SELECT like: select a.UserGroupId,b.UserGroupId from view1 a full outer join view1 b on b.UserGroupId = a.UserGroupId WHERE a.StartTime >= '2
