looking for wich table type to use with select command

[pg75]

Hello,
I would like to make a request to retrieve the number of test cases KO, the number of test cases in failure for the entire test project
I don't know which table type I could use in my sql select for doing this request with SELECT command ...
some people in my company want more results than what is offered by the interface Testlink
thanks lot for you help

[GunnarD]

On mantis u can find a picture of the database schema: http://mantis.testlink.org/view.php?id=4004

[pg75]

thanks lot for you help