SQL Tuning

From: <karmst_at_usa.net>
Date: Mon, 19 Apr 1999 22:35:04 GMT
Message-ID: <7fgb2o$65a$1@nnrp1.dejanews.com>

Hi,

I have defined a view by joining three tables.

One of the columns in the view is market_promotion_id. The result set returns 25 records, but 10 of these contain the same market_promotion_id from the market_promotion table - this occurs because of the way joins returns multiple records from the other tables for the same market_promotion_id.

Is there a way to return only 1 instance of market_promotion_id (i don't care which one), so that 9 out of 10 market_promotion_ids disappear.

thanks a million

keith

PS - if you know a solution please reply to both karmst_at_usa.net and shangud_at_yahoo.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 19 1999 - 17:35:04 CDT