Hi all.

Im new to this forum and to asp i have to say i have found this site invalubale in starting on the long road to lerning to programe using asp. I have searched the net wide and far for over a year and a half now for a asp tutorial and found them all to dificult to follow untill i found the tutorials within this site. Thanks to this site i have now produced my first asp script and started work on my second if you want to see my first you can see it here http://www.sell-uk.net/gbfree/view.asp - http://www.sell-uk.net/gbfree/view.asp Although this site has been an insperation i find myself at the point wher i would like to progress and my second project has a database with more than one table although the tutorials on this site are a great help they do not explane how to encoperate more than one database table into one asp page. This is what i would like for somone to please explaine to me please remember that im a compleat newbe to this and do not fully understand what things do what all i need to know is HOW do i use two database table that are not related in one asp page I.E one table would be the maine script table and the second would be a config table with bacground info text type and so on.

How do i do this

REGARDS

NATHAN

'You general database connection here you only need that once unless they are 2 diff db's

strSQL1 = "Select * from table1"
set rs1 = conn.Execute(strSQL1)
If rs1.BOF or rs1.EOF THEN
 'Give message
ELSE
 WHILE NOT rs1.EOF
     Display your data
 rs1.MoveNext
 WEND
END IF

Set rs1 = NOTHING

strSQL2 = "Select * from table2"
set rs2 = conn.Execute(strSQL2)
If rs2.BOF or rs2.EOF THEN
 'Give message
ELSE
 WHILE NOT rs2.EOF
     Display your data
 rs2.MoveNext
 WEND
END IF

Set rs2 = NOTHING

'Close your db connection here