SQL being modelled in BO Designer

[Craig21]

Hi,

I have a number of SQL statement's and as I'm new to Business Objects, what is the best way for them to be modelled using designer.

Example 1.

Select abc
FROM
abc
SummaryRatesAndPricesRec a
WHERE ALI_HAS_LEND = AssetLiabilityItem_TIL
AND a.SummaryRatesAndPrices_TIL = (SELECT MAX(b.SummaryRatesAndPrices_TIL) FROM SummaryRatesAndPricesRec b WHERE b.SRP_HAS_RPC = a.SRP_HAS_RPC)

Example 2.

Select abc
FROM abc
WHERE
SummaryRatesAndPricesRec b WHERE b.SRP_HAS_RPC = SRP_HAS_RPC)
AND TDBCode = RPCODECode
UNION
SELECT
HDEALDealNumber AS "Deal Number",
etc..

Many Thanks for your help

Craig