Search results

  1. S

    Order by a subquery

    yes that was a typo, i also realised the ORDER BY had artist instead of artists. so fixed those. But the same error appears, all the tables have the ID field but not every table has every ID in it. users keeps all the ID's but they are only entered into the other table if the user chooses to...
  2. S

    Order by a subquery

    Cheers Galaxiom, that's had the added benefit of cleaning up my code. Unfortunately its been giving me an error I cannot find the solution for: Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /testerproductsByCategory.asp, line 144 Line 144...
  3. S

    Order by a subquery

    I have been working with SQL queries for a while now but only recently has there been a need to introduce sub queries. The following code works fine but I now need to be able to order the data by “table4.price” I have tried adding “ORDER BY table4.price” to the very end of the string and...
Back
Top Bottom