Example 1 Select s.usize, s.uname, s.ppu, s.gcode, s.ccode, s.Ino, s.BCode, s.IName, .loccode, s.CPU, s.qty, (s.CPU * s.qty) AS TotalCost ; FROM tempStock1 s ; WHERE NOT s.Ino IN (SELECT Ino FROM csrLPQty) and ; NOT (s.loccode in (select loccode from csrLPQty))) ; UNION ; SELECT usize, uname, ppu, gcode, ccode, Ino, BCode, IName, loccode, CPU, qty, (CPU * qty) AS TotalCost ; FROM csrLPQty ; into cursor tempStock Example 2 Select s.usize, s.uname, s.ppu, s.gcode, s.ccode, s.Ino, s.BCode, s.IName, s.loccode, s.CPU, s.qty, (s.CPU * s.qty) AS TotalCost ; FROM tempStock1 s, csrLPQty l ; WHERE (s.Ino <> l.INo AND s.LocCode <> l.LocCode) ; UNION ; SELECT usize, uname, ppu, gcode, ccode, Ino, BCode, IName, loccode, CPU, qty, (CPU * qty) AS TotalCost ; FROM csrLPQty ; into cursor tempStock