<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim qry DIM SQLStmt SQLStmt = "SELECT p.Name AS P_Name, p.Year, p.ID, p.Include, u.Number, i.Name AS I_Name, i.PluralName " SQLStmt = SQLStmt & "FROM Piece AS p " SQLStmt = SQLStmt & "LEFT OUTER JOIN (InstrumentsUsed AS u LEFT OUTER JOIN Instrument AS i ON u.Instrument = i.ID) ON p.ID = u.Piece " SQLStmt = SQLStmt & "WHERE p.Include = TRUE " SQLStmt = SQLStmt & "ORDER BY p.name" Set qry = oConn.Execute(SQLStmt) %> Pieces Listed Alphabetically

Pieces Listed Alphabetically

 
 
© Jesse Guessford / Antisuess Music August 10, 2008