I have the following code in my asp page:
SELECT *
FROM [Template Properties]
WHERE activeScheme
This is good as it does what I need. However I have another table that I need information from. I dont think I am right in saying I can simply create a new recordset, as I think this maybe the incorrect way of doing it.
But is it possible to have something like this (obviously it is wrong as it did not work for me, but maybe someone has a clue on how to achieve this.
SELECT *
FROM [Template Properties] AND [Page Properties]
WHERE activeScheme
In other words I basically want to connect to two tables, does anyone know how???
Cheers
