My SQL-string is the devil !

[alcstudio]

Hello there i have made a SQL-string thats the devil him self.

Here is the working one, here its take the value "Tim" from same table wich is "kostnader" but i want to take the "Tim" value from another table.

Working code

SQL = "SELECT projekt.projekt, projekt.id, projekt.lock, (SELECT COUNT(ID) FROM kostnader WHERE kostnader.personal_id = "& session("id") &" AND kostnader.projekt_id = projekt.id)  AS antal, (SELECT SUM(varde) FROM kostnader WHERE kostnader.projekt_id = projekt.id AND kostnader.personal_id = "& session("id") &" AND kostnader.enhettim = 'Tim') AS antaltim FROM projekt "
 

And here is what iam trying to do, its just the end thats different in this string.
Instead of kostnader.enhettim = 'Tim' i have this to get the value from another table priskategori.enhet = 'Tim'

The table priskategori and colum enhet dose exist so dont get this-.

The error iam haveing is this.

* No value given for one or more required parameters.

[alcstudio]

Sorry for this dubble post but in other forum the response is quick, but i guess that the most of the members are asleep. Iam living in sweden so the clock is not the same i guess.,

[alcstudio]

Anyone knows why i get this error, nothing in the database is wrong anyway :D

[jhardman]

Hello there i have made a SQL-string thats the devil him self.

Here is the working one, here its take the value "Tim" from same table wich is "kostnader" but i want to take the "Tim" value from another table.

Working code

SQL = "SELECT projekt.projekt, projekt.id, projekt.lock, (SELECT COUNT(ID) FROM kostnader WHERE kostnader.personal_id = "& session("id") &" AND kostnader.projekt_id = projekt.id)  AS antal, (SELECT SUM(varde) FROM kostnader WHERE kostnader.projekt_id = projekt.id AND kostnader.personal_id = "& session("id") &" AND kostnader.enhettim = 'Tim') AS antaltim FROM projekt "
 

And here is what iam trying to do, its just the end thats different in this string.
Instead of kostnader.enhettim = 'Tim' i have this to get the value from another table priskategori.enhet = 'Tim'

The table priskategori and colum enhet dose exist so dont get this-.

The error iam haveing is this.

* No value given for one or more required parameters.

Sorry, it took me a minute to understand you. It's not that your english is really bad, it's that you use a more complicated query than I use. I always try to keep my sql very basic and I put my complex codes in the ASP script.

First off, how is the table "priskategori" related to the other tables? (for example I can tell that the relationship between "kostnader" and "projekt" is that "kostnader.projekt_id = projekt.id")

Jared