I have copied the SQL below,

SELECT Oimods.iid, Oimods.ioitemid, Oimods.imodid, Oimods.ipricegpid,;
Order.order_no, Order.cticket, Oimods.ctktname, Oimods.iinvid,;
Oimods.laddtobase, Oimods.nprice, Oimods.iqty, Oimods.cfraction,;
Oimods.cmodified;
FROM prism!oimods INNER JOIN prism!oitems;
INNER JOIN prism!order ;
ON Oitems.iorderid = Order.iid ;
ON Oimods.ioitemid = Oitems.iid;
WHERE Order.order_no = ?vp_order_no;
ORDER BY Oimods.ioitemid, Oimods.imodid


Again, any help would be appreciated.

John Rowlinson
Microworks POS Solutions