if(myFlag.equals("") || isFlagPirate.equals("N")){

    //get list of available ship id, ship name as options for the ship dropdown list
    sqlShipListString =
            "select distinct ship.ship_id, ship.name from admiralty_branch  " +
                    "left join ship on ship.ship_id=admiralty_branch.ship_id " +
                    "where admiralty_branch_id= " + admiraltyid +
                    " order by ship.name";

}else{

    if(isFlagPirate.equals("Y")){

        //get list of available ship id, ship name as options for the ship dropdown list
        sqlShipListString =
                "select distinct ship.ship_id, ship.name from ship  " +
                        "left join ship_type on ship.ship_id=ship_type.ship_id " +
                        "left join fleet on ship_type.fleet_id=fleet.fleet_id " +
                        "where fleet_id= " + fleetId +
                        " order by ship.name";
    }
}