Bradley Kieser <[EMAIL PROTECTED]> writes:
> When I run it, it returns 36 rows.
> Now, if I cut and paste simply the SELECT part and run it, I get the
> correct number of rows, 170.
If you can reproduce this on something more recent than 7.1, I'd
appreciate seeing a complete (self-contained) ex
Hi,
I created a view with this SQL:
create view category_type
as
select l1.id as cat_id, l1.description as cat_desc,l2.id as cat_typ_id,
l2.description as cat_type_desc,p.id as link_id
from levels l1
join product_category p on p.category = l1.id
and p.category
