TYPE ptype [pnum] pnum,desc,weight,color,price TYPE stype [snum] snum,sname,city,status TYPE prtype [prnum,snum] prnum,snum,city TYPE sptype [snum,pnum,prnum] snum,pnum,prnum,qty OPEN pr prtype OPEN sp sptype OPEN s1 stype OPEN p1 ptype OPEN p2 ptype OPEN sp2 (p1 UNION p2) JOIN sp (p1 UNION p2 JOIN sp1 (p1 UNION p2 sp1 (p1 UNION s2) JOIN sp1 (p1 INTERSECT p2) TIMES s1 (p1 INTERSECT p2) TIMES p1 (p1 INTERSECT p2) TIMES s1h (p1 INTERSECT p2) s1h (p1 INTERSECT p2 1h p1 JOIN p2 p1 TIMES P2 (p1 WHERE pnum = " 9") UNION (p2 WHERE pnum = " 9") (p1 WHERE pnum = " 9") MINUS (p2 WHERE pnum = " 9") (p1 WHERE pnum = " 9") INTERSECT (p2 WHERE pnum = " 9") (p1 WHERE pnum = " 9") INTERSECT p2 WHERE pnum = " 9") (p1 WHERE pnum = " 9") INTERSECT (p2 WHERE snum = " 9") (p1 WHERE pnum = " 9") INTERSECT (p2 WHERE pnum = 9) ((p1 WHERE pnum = " 9") UNION (p2 WHERE pnum = " 9")) [pnum,desc,price] ((p1 WHERE pnum = " 9") UNION (p2 WHERE pnum = " 9")) [desc,price] ((((p1 WHERE pnum = " 9") JOIN sp1) [snum]) JOIN s1) [name] ((((p1 WHERE pnum = " 9") JOIN sp1) [snum]) JOIN s1) [name,city] (s1 join pr) [snum,city,status]