how can i display this?

Hello everybody,
I need some help in display some information from two temporal tables.
In first table i have this:
Table 1(idl, companyorg, article, firstprice)
Table 2(idli, companyparticipate, last price, datatime1)
the result i want to look like this:
companyorg article fistprice
companyparticipate lastprice datatime1
companyorg article fistprice
companyparticipate lastprice datatime1
companyparticipate lastprice datatime1

it is posilbe that the companyorg which organised an auction can have 2 companies or more who participated at this. so I want under evry companyorg to dispaly all companies participated. I want to do this without cursor.

Where do you want to show these data like this?<br />Are you using any Front End Application?<br />If so you can do this there [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

When you want to display this in a report why don't you use the formatting features of your report writer and insist of finding an, at best, kludgy solution in T-SQL??? Such hierarchical reports should be an easy exercise of any reporting tool.

I have a big database who can return for one company more than an entrance, I can have more that 100 companies. So I do this report in SQL and then I will put it in excell. Can you explain me how can i do this?