Hi All,

I hope someone here can point me in the right direction. I want the
total quantity due from a detail table which I get like this:

CREATE VIEW SODetailDueView AS
SELECT PRTNUM_28, SUM(DUEQTY_28) AS DueQty
FROM "SO Detail"
WHERE STATUS_28='3'
GROUP BY PRTNUM_28;

Then I want to use the results from this view joined with two other
tables like this:

CREATE VIEW PriceAvailView AS
SELECT PRTNUM_88, CUSTYP_88, ONHAND_01, DueQty
FROM "Price Breaks"
LEFT JOIN "Part Master" ON PRTNUM_88=PRTNUM_01
LEFT JOIN SODetailDueView ON PRTNUM_28=PRTNUM_01;

Both creates seem to work fine from Pervasive.SQL version
8.00.114.000's Data Manager but when I try to use them like:

SELECT * FROM PriceAvailView;

I get:

ODBC Error: SQLSTATE = S1000, Native error code = 0
Grouped view joins are not supported.

Is there some other way to approach this that might be allowed by
Pervasive version 8?

Thanks for any help you can provide,
Dale