 |
|
|
|
|
|
|
SELECT MEMBS.ID, MEMBS.NMESUR, MEMBS.DATECR, MEMBS.DATEMD, MEMBS.MEMBTYP_CODE,
MEMBS.DESCLO, MEMBS.DESCSH,
ATT1TYPS.DESCRIP,
EATTS.month, EATTS.day, EATTS.year,
EATTS.timeinfo, EATTS.length, EATTS.url, EATTS.url as PELINK, EATTS.location,
EATTS.othinfo, EATTS.PUBEND
FROM MEMBS, ATT1S, ATT1TYPS, EATTS, events
WHERE MEMBS.MEMBTYP_CODE IN ('EVENT')
AND events.id = membs.id
AND ATT1S.ATT1TYP_CODE = 'EVCOM'
AND ATT1S.MEMB_ID = MEMBS.ID
AND EATTS.MEMB_ID = MEMBS.ID
AND ATT1S.ATT1TYP_CODE = ATT1TYPS.CODE
AND MEMBS.APPROV =1
ORDER BY NMESUR
#NMESUR#
#DESCSH#
|
|
|
