I have a query built to extract data. No errors when it runs however it gets some of the data but not all of the data. Below is an example of the query and the results. Here is an example... Each job has a PO and multiple lines it might get line 2,3,5,7 but miss 1,4,6,8


Here is the example. This is in sql 2005

--select * from p21_order_view
--
use p21
select p21_order_view. order_no,...