Help for this page

Select Code to Download

Select or download this

SELECT *
FROM sp
...
    FROM supplier     -- note SP doesn't appear here!
    WHERE supplier.num = sp.num  -- sp is from main query
)