Can I loop through the output of 2 select statements from a stored procedure based on a "order by a date" that is in the 2 different databases. For example I want to
select * from program where cust_no = '125'
Program has a field "posted"
select * from history where cust_no = '125'
history has a field "posted".
Then I want to loop through the 2 selects display each line item in order by the date. I cannot use an inner join cause it will list the program for each line of history