回覆列表
  • 1 # 使用者3417633067606

    用union all

    假設列名分別為 col1 cola colb...

    select col1,cola

    from tabname

    where ...

    union all

    select col1,colb

    from tabname

    where ...

    union all

    select col1,colc

    from tabname

    where ...

    union all

    select col1,cold

    from tabname

    where ...

    union all

    select col1,cole

    from tabname

    where ...

    union all

    select col1,colf

    from tabname

    where ...

  • 中秋節和大豐收的關聯?
  • 去眼袋哪種方法好?