Hi all,

I just need confirmation as to the efficiency of the SQL code in the Source
Table. I placed the 4 TIB_lookupCombo's in a grid:-

The Source Table reflects the relationship between MARKETER, FUND,
OPTION(FUND) and GROUP.

SELECT
PERSONID
, OPTIONNAME
, FUNDNO
, GROUPNAME
, MARKETERID
, DOI
, (SELECT NAME
FROM FUND f
WHERE f.FUNDNO=m.FUNDNO)
AS THEFUNDNAME
, (SELECT FIRSTNAME
FROM MARKETER a
WHERE a.PERSONID=m.PERSONID)
AS MARKETERNAME
, (SELECT NAME
FROM GROUPS g
WHERE g.NAME=m.GROUPNAME)
AS GROUPNAME
FROM MEMBERINFUND m

WHERE (m.PERSONID = :APERSONID)

Thanks,
Dion.

>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>