Re: Too many results in my Query

[Peter Brawley]

> some results do not contain that key word but show up anyway.

For us to discern the reason, you'd have to post enough data to reproduce the problem. Meanwhile the query has obvious problems ...

1. Are you aware that ...LEFT JOIN process ... LEFT JOIN summary ... WHERE summary.<colname> LIKE ... turns those LEFT JOINs into INNER JOINs?

2. The need to search seven summary columns for one keyword value strongly suggests the summary table needs further normalisation, eg to ...

summary(sid PK, processid references process...)
summarylabels(labelid PK, label varchar(64)
summaryitems( itemid PK, sid references summary(sid), label reference summarylabels(label), description ...)



Edited 1 time(s). Last edit at 11/12/2012 08:53AM by Peter Brawley.