hi ,can somebody help me? today i meet a very strange question. the follw is the sql. please notice the line 2 , a null be assigned to the name , when i execute this sql , the follow column is also null no matter if it's really have value. *select temp13636650632.ID as ID,* * null as NAME,* * temp13636650632.CODE as CODE,* * temp13636650632.INTVALUE as INTVALUE,* * temp13636650632.LONGVALUE as LONGVALUE,* * temp13636650632.FLOATVALUE as FLOATVALUE,* * temp13636650632.DOUBLEVALUE as DOUBLEVALUE* * from temp13636650632* *union all* *select temp13636650631.ID as ID,* * temp13636650631.CODE as NAME,* * temp13636650631.NAME as CODE,* * null as INTVALUE,* * null as LONGVALUE,* * null as FLOATVALUE,* * null as DOUBLEVALUE* * from temp13636650631* *union all* *select temp13636650630.ID as ID,* * temp13636650630.NAME as NAME,* * temp13636650630.CODE as CODE,* * temp13636650630.INTVALUE as INTVALUE,* * temp13636650630.LONGVALUE as LONGVALUE,* * temp13636650630.FLOATVALUE as FLOATVALUE,* * temp13636650630.DOUBLEVALUE as DOUBLEVALUE* * from temp13636650630*
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
