in reply to Re^5: output results from sql joinin thread output results from sql join
it has worked now, thanks poj and roboticus