Joining two external tables programatically

Hi all.
I have an IBM iSeries here at work. What I want to do is join say the customers table and the orders table programatically in an ASPX page and view the results in a Gridview?

This may be an SQL question or maybe use Linq? I really don't know.
Can someone shed some light on this for me please?