i hate it when my girlfriend used this on me:
select RA.ID ALERT_ID, RA.BIRDTRACK_LEVEL_ID BIRDTRACK_LEV, ATP.NAME ALERT_NAME, NT.NAME WEAPON_SYSTEM
from CMMSDBA.RETAIL_ALERTS RA, CMMSDBA.NAVIGATION_TREE NT, CMMSDBA.ALERT_TYPES ATP
where RA.NAVIGATION_TREE_ID = nNavTreeID
and RA.ALERT_TYPE_ID = ATP.ID
and NT.NAVIGATION_TREE_TYPE_ID <> nAirStationType
and NT.PARENT_ID = nAirStationID
and RA.BIRDTRACK_LEVEL_ID <> nBirdTrackLev
and RA.ID NOT IN ( select RETAIL_ALERT_ID from CMMSDBA.MY_ALERTS_RETAIL where USER_ID = iUser )
group by NT.NAME, RA.BIRDTRACK_LEVEL_ID, RA.ID, ATP.NAME
it hurt my feelings.
select RA.ID ALERT_ID, RA.BIRDTRACK_LEVEL_ID BIRDTRACK_LEV, ATP.NAME ALERT_NAME, NT.NAME WEAPON_SYSTEM
from CMMSDBA.RETAIL_ALERTS RA, CMMSDBA.NAVIGATION_TREE NT, CMMSDBA.ALERT_TYPES ATP
where RA.NAVIGATION_TREE_ID = nNavTreeID
and RA.ALERT_TYPE_ID = ATP.ID
and NT.NAVIGATION_TREE_TYPE_ID <> nAirStationType
and NT.PARENT_ID = nAirStationID
and RA.BIRDTRACK_LEVEL_ID <> nBirdTrackLev
and RA.ID NOT IN ( select RETAIL_ALERT_ID from CMMSDBA.MY_ALERTS_RETAIL where USER_ID = iUser )
group by NT.NAME, RA.BIRDTRACK_LEVEL_ID, RA.ID, ATP.NAME
it hurt my feelings.
0 Comments:
Post a Comment
<< Home