J.D.

Recent Blog Comments By J.D.

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Oct 21, 2009 at 11:17 AM

  sorry for asking a sql question (I am sorry for if it's ok not to ask in here) I spend 1 week to think out how to finger out this soluction SELECT SHOPNO,HWSNO,BDATE,HPYNO FROM ECRPYHS RESULT: SHOPNO HWSNO BDATE HPYNO A 01 2004/06/15 01 A ... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Aug 11, 2009 at 10:14 PM

  hi thank you Andrew Bauer I just tried to convince them to let me change the schema , but ... in vain , for some reason they just want this kind of schema to save data.. maybe I will try the way ( use other code languae ) to get the result I need thanks for your patient and suggestion !! thanks... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Aug 10, 2009 at 10:17 PM

  hi, Andrew Bauer again thanks for your reply !! I been google for find the answer people just siad like you just told not suggest to save mutiple value in same column.. but the schema and exist data just save like this format.. ( I can't change schema... which old Data exist many data row al... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Aug 10, 2009 at 3:26 AM

  thanks Andrew Bauer :D may I ask do you know does SQL can do "split" like C# can do? in my column save data like this Table A SHOPNO GOODS 101`102 BANANA Table B SHOPNO SHOPNAME 101 SUN 101 MOON is it possible to split A.SHOPNO then compare with B.SHOPNO to... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Aug 6, 2009 at 3:04 AM

  hi, does this syntax also suit for Insert Query?... read more »