$sql="SELECT S.SLOCATIONCODE FROM SUBLOCATION S INNER JOIN LOCATION L ON L.LOCATIONID = S.LOCATIONNAME WHERE (L.LOCATIONCODE = '$loca' OR '$loca' ='ALL' ) UNION ALL SELECT 'ALL' FROM DUAL";
$sql="SELECT S.SLOCATIONCODE FROM SUBLOCATION S INNER JOIN LOCATION L ON L.LOCATIONID = S.LOCATIONNAME WHERE (L.LOCATIONCODE = '$loca' OR '$loca' ='ALL' ) UNION ALL SELECT 'ALL' FROM DUAL";