× This is the optional Forum header for the Suggestion Box.

How do I write a query using Additional Condition

Start
Prev
1
Next
End

Mikhail
Topic Author
Offline
New Member

11 years 4 days ago #2209

How do I write a query using
Additional Condition:

SELECT training_year, category_stud, education_prog, sum(state_order), sum(subvention)
FROM acmw3_request
GROUP BY training_year, category_stud, education_prog

Last edit: 11 years 4 days ago by Mikhail.

Please Log in or Create an account to join the conversation.

tomaz
Offline
Administrator

11 years 4 days ago #2210

Hi,

The "Additional Condition" option only applies to the where statement of the query. If you want to perform more complicated queries I suggest you to use database view. Here is an article about it.

toolsjx.com/faq/3-how-to-create-a-databa...use-it-with-tools-jx

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

How do I write a query using Additional Condition

Contact Us

Contact us on Discord

Contact us on Facebook