On 15 Jan 2003, at 20:13, Ken Easson wrote:
> SELECT DISTINCT price FROM sys_bld_foo WHERE catNum IN
> ('item1', 'partA', 'partB', 'partB');
It's possible that the query you want is
SELECT DISTINCT catNum, price FROM sys_bld_foo
WHERE catNum IN ('item1', 'partA', 'partB', 'partB');
or
SELECT catNum, MAX(price) FROM sys_bld_foo
WHERE catNum IN ('item1', 'partA', 'partB', 'partB')
GROUP BY catNum;
Maybe MAX() in the second one should be MIN() or AVG(), or maybe it
doesn't matter. I still don't understand why your table repeats the
price each time a catNum appears (rather than having a separate table
of parts, or whatever the catNum represents, that includes the price
and other data for each), nor why you say that normalizing would
require 20 new tables. But if you don't want to normalize, good
luck!
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
