On 2/14/2015 6:55 PM, R.Smith wrote: > > On 2/14/2015 6:32 PM, Bart Smissaert wrote: >> Having problems with the following SQL: >> >> 2 tables, trying to count occurrence of field 2 and field 3 of table 1 >> in field 1 (only field) of table 2. ...
> I haven't tested it, but my quick-scan answer would be//.... Oops - After seeing Igor's reply, I realized those "COUNT" statements in my last examples should better be SUM statements since count will give row-hits not item totals.
