"select "+pPrototype1+", "+pNomenclature2+"\n"+ "from "+protoTable+" "+abbrev1+", "+protoTable+" "+abbrev2+"\n"+ "where "+pPrototype1+" <> "+pPrototype2+" and "+pNomenclature1+" = "+pNomenclature2+"\n"+
"select "+pPrototype1+", "+pNomenclature1+"\n"+ "from "+protoTable+" "+abbrev1+"\n"+
  private String getQuery (int run) {    String protoTable = Controller.getTableName(DGPSPConstants.ASSET_PROTOTYPE_TABLE,run);    String abbrev1 = "p1";    String abbrev2 = "p2";    String pPrototype1 = abbrev1+"."+DGPSPConstants.COL_PROTOTYPEID;    String pNomenclature1 = abbrev1+"."+DGPSPConstants.COL_ALP_NOMENCLATURE;    String pPrototype2 = abbrev2+"."+DGPSPConstants.COL_PROTOTYPEID;    String pNomenclature2 = abbrev2+"."+DGPSPConstants.COL_ALP_NOMENCLATURE;    String sqlQuery =      "select "+pPrototype1+", "+pNomenclature2+"\n"+      "from "+protoTable+" "+abbrev1+", "+protoTable+" "+abbrev2+"\n"+      "where "+pPrototype1+" <> "+pPrototype2+" and "+pNomenclature1+" = "+pNomenclature2+"\n"+      "order by "+pNomenclature1;    return sqlQuery;  }