using joins in the query

Results 1 to 2 of 2

Thread: using joins in the query

  1. #1
    Join Date
    Dec 1969

    Default using joins in the query

    I m trying to display the data usin equi join in the script...but Response.Write is not seem to b working..a small snippet is given below.. please tell me what i m doin wrong here.<BR><BR>sql="select table1.ID, from table1, table2 where table1.ID=table2.ID and"<BR>set rs=conn.execute(sql)<BR>Response.Write rs("table1.ID")<BR><BR>the above snippet generates the error<BR><BR>"ADODB.Fields error &#039 800a0cc1&#039 <BR><BR>ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application. "<BR><BR>I m using MySql as the Database engine!

  2. #2
    Join Date
    Dec 1969

    Default RE: using joins in the query

    that SQL statement isn&#039t joined right. Check out the article at on Inner Joins<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts