Results 1 to 2 of 2

Thread: Subqueries

  1. #1
    shelz Guest

    Default Subqueries

    Will ASP let you do SQL subqueries? If so what would be the syntax on something like below?<BR><BR>objCommand.CommandText= "SELECT CM_ID, tt_project_id "&_<BR> "FROM tbl_Super_Customer "&_<BR> "WHERE tt_project_ID=" & CustID <BR> I would like the results of this query to be inserted into another query.

  2. #2
    Join Date
    Dec 1969

    Default RE: Subqueries

    Of course, just use the results from the first SQL command to build the next SQL query string.

Posting Permissions

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