Hello folks. I currently have a table:
create table t_gloss(entryid integer, type integer, value text); and am running this SQL on it: select entryid,type from t_gloss where value=?; then for each row returned (type is type==0?1:0 from above row, and entryid is the same): select value from t_gloss where entryid=? and type=? order by value; This already runs nice and speedy due to indexes, but I am wondering if it could be combined into one query for further efficiency. Any ideas? -- Cory Nelson http://www.int64.org
