Sure you can. You can use the view designer if you're more comfortable with that, or you can do it in code like this:

CREATE DATABASE ViewsDBC

CREATE SQL VIEW OrdTots AS ;
   Select pid, SUM(...) as OrdTotal ;
      From c:\qn\datatemp... ;
      GROUP BY pid

CREATE SQL VIEW InvTots AS ;
   Select pid, SUM(...) as InvTotal ;
      FROM c:\qn\datatemp... ;
      GROUP BY PID

This will give you two non-updatable views. (If you want them updatable, you have to set a bunch of properties.)

Now that you have totals for orders and invoice by Pid, you can create your third query.