I am trying to merge data from 2 different tables without actually having to create a view in the database, then display it on the screen.
What I did was first actually create the view, then try to use the SQL code it generated in my ASP page.
SELECT dbo.Table1.*, dbo.Table2.zProjectID FROM dbo.Table1 INNER JOIN dbo.Table2 ON dbo.Table1.zCRFID = dbo.Table2.ID
This works fine within the database, but when I try and use this to get a record set it gives me the error [ ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. ]
This is what I want to do....
myStr="SELECT dbo.Table1.*, dbo.Table2.zProjectID AS Expr1 FROM dbo.Table1 INNER JOIN dbo.Table2 ON dbo.Table1.zCRFID = dbo.Table2.ID"
set myRecord=server.CreateObject ("ADODB.Recordset")
So my question is this even possible and if so what am I doing wrong?