Difference between revisions of "Frances email 1"

From MyWiki
Jump to: navigation, search
Line 13: Line 13:
 
  Frances<br>
 
  Frances<br>
  
  mysql> select cs_st_code,cs_st_sur, prereg,username from srs where cs_st_code ='33374637';
+
  mysql> select cs_st_code,cs_st_sur, prereg,username from srs where cs_st_code ='33374637'; ( missing from srs table )
 
  Empty set (0.00 sec)
 
  Empty set (0.00 sec)
  
 
  33348713  | Tsai      | Y      | eu401ht
 
  33348713  | Tsai      | Y      | eu401ht
 +
  33374757  | Araujo    | Y      | ie401da  ( looks fine )

Revision as of 20:27, 24 May 2014

Dear George
The below do no have a network username
 33374637	  OH	  MIN	  2014-01-06	  CIDP	  100358B
 33348713	  TSAI	  HSI-YU	  2014-05-26	  ELU	  330019C
 33374757	  ARAUJO	  DANIELA	  2014-06-13	  ICCE	  270003A
 33377303	  MARSEILLAN	  JIMENA	  2014-06-13	  ICCE	  270003A
Thanks


Frances
mysql> select cs_st_code,cs_st_sur, prereg,username from srs where cs_st_code ='33374637'; ( missing from srs table ) 
Empty set (0.00 sec)
33348713   | Tsai      | Y      | eu401ht
 33374757   | Araujo    | Y      | ie401da   ( looks fine )