RE: FN-FORUM: Sql query help

date posted 14th January 2004 13:54

Yep that works, still got an execution time of 0.27 seconds though.

It's definately the join that is inneficient. I've added an index to the
barcode field, but it didn't seem to help.

But I'm so much better off than I was this time yesterday. Thanks everyone
for your help.

Ron
(Fixed his Dev server. How long does MySQL take to compile???)