How to filter a dataset using relationships like a sqlcommand   

Hi,

I have a dataset with many ralated datatables, i need execute filter 
that gives back datarows to me that gives back to me if outside the 
following SQL command.

SELECT  distinct   GE_SERVICE_TYPE.SERVICE_TYPE_ID, 
GE_SERVICE_TYPE.DESCRIPTION
   FROM  PS_PACKAGE_TYPE,
         CC_COMMERCIAL_PLAN,
         PS_PRD_MOTIV_PACKAGE,
         CC_PRODUCTS_BROCHURE,
         PS_PRODUCT_MOTIVE,
         GE_SERVICE_TYPE,
         PS_PRODUCT_TYPE
WHERE PS_PACKAGE_TYPE.PACKAGE_TYPE_ID = 
CC_COMMERCIAL_PLAN.PACKAGE_TYPE_ID AND
       PS_PACKAGE_TYPE.PACKAGE_TYPE_ID = 
PS_PRD_MOTIV_PACKAGE.PACKAGE_TYPE_ID AND
       CC_COMMERCIAL_PLAN.COMMERCIAL_PLAN_ID = 
CC_PRODUCTS_BROCHURE.COMMERCIAL_PLAN_ID AND
       PS_PRD_MOTIV_PACKAGE.PRODUCT_MOTIVE_ID = 
PS_PRODUCT_MOTIVE.PRODUCT_MOTIVE_ID AND
       PS_PRODUCT_MOTIVE.PRODUCT_TYPE_ID = 
PS_PRODUCT_TYPE.PRODUCT_TYPE_ID AND
       GE_SERVICE_TYPE.SERVICE_TYPE_ID = PS_PRODUCT_TYPE.SERVICE_TYPE_ID
AND (CC_PRODUCTS_BROCHURE.MARKETING_SEGMENT_ID = :MARKETING_SEGMENT_ID)

Which is the best way to obtain this?

Thanks beforehand for the collaboration.

Greetings.

Alvaro.

date: Tue, 18 Apr 2006 19:17:58 -0500   author:   Alvaro E. Gonzalez