Opasnet base structure

From Opasnet
Revision as of 08:44, 31 December 2007 by Jouni (talk | contribs) (some useful syntax stored)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Result database is for storing variable results in a way that they can be used independently of the assessment they were created in.

Some useful syntax

http://www.baycongroup.com/sql_join.htm


SELECT * FROM `Result`, `Location`, `Variable` where `Result`.`Result_id` = `Location`.`Result_id` and `Result`.`Var_id` = `Variable`.`Var_id` and sample <11