<div>
Thanks angelIII that works great !<br />
<br />
one thing through I dont really understand the code, could explain it if possible ?<br />
<br />
thanks<br />
again
</div>


Thanks angelIII that works great !

one thing through I dont really understand the code, could explain it if possible ?

thanks
again

<div>
the inner query returns the data you want, only the order by is &quot;missing&quot;<br />
<br />
the outer query uses that data, and just orders by the field tpoints you generated in the inner query.<br />

</div>


the inner query returns the data you want, only the order by is "missing"

the outer query uses that data, and just orders by the field tpoints you generated in the inner query.


<div>
<div class="content wysiwyg-content">
I have an sql statement that I want to order by points but I can not get it to work<br />
<br />
I'm using asp, vbscript<br />
<br />
code:<br />
<br />
SELECT *,(SELECT SUM(points)<br />
FROM teams<br />
WHERE teams.teamid = users.id) AS Tpoints FROM Users<br />
<br />
when I try :<br />
<br />
SELECT *,(SELECT SUM(points)<br />
FROM teams<br />
WHERE teams.teamid = users.id) AS Tpoints FROM Users<br />
ORDER BY Tpoints<br />
<br />
I get an error 'Too few parametera' Expected 1<br />

</div>
</div>


I have an sql statement that I want to order by points but I can not get it to work

I'm using asp, vbscript

code:

SELECT *,(SELECT SUM(points)
FROM teams
WHERE teams.teamid = users.id) AS Tpoints FROM Users

when I try :

SELECT *,(SELECT SUM(points)
FROM teams
WHERE teams.teamid = users.id) AS Tpoints FROM Users
ORDER BY Tpoints

I get an error 'Too few parametera' Expected 1


How do I order my sql select query by the result of the sum?

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.