Nested SQL in ASP

Results 1 to 2 of 2

Thread: Nested SQL in ASP

  1. #1
    Join Date
    Dec 1969
    Posts
    22

    Default Nested SQL in ASP

    What is the syntax for nested SQL in ASP?<BR><BR>strSQL = "SELECT * FROM Technotes where Category = <BR>&#039" &FReference & "&#039 ("SELECT Subject, Summary FROM Technotes where Reference = &#039" & FReference & "&#039)"<BR><BR>Above syntax doesn&#039t work!<BR><BR>Thanks and best regards!

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Nested SQL in ASP

    What, exactly, are you trying to do? You have two SQL statements side by side. Are you trying to use a derived table? Or a subquery? Or two separate queries?

Posting Permissions

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