First question...is there a site similar to this one for ASP Q and A?

Now...here's my ASP question....

Here's my challenge. All fields are not defined here...

Table "Customers"

row=1 field=SalesPerson value=2
row=1 field=CustomerEngineer value=6

Table "People"

row=1 field=id value=2
row=1 field=name value=name1
row=2 field=id value=6
row=2 field=name value=name2

My question is...since table "Customers" has a need to call two "name" fields from table "People"...how do I query the tables and have asp post the data to the page as follows:

html page

salesperon: name1
customer engineer: name2

Do you see the complication here??? It has boggled my mind...at first I run an inner join query...it works, but guess what...it gives me "name1" for both the salesperson and customer engineer.

Here's the problem when I run the join query...

the asp page calls.... request.write(rsResults.Fields("name")) ....

see the problem??

Should this be a simple task?? Will includes or global.asa ever come into play...help, please?!

Thanks,
Dave