问一个数据库视图的写法??
现有表T:
-------------
f1 | f2 | f3
-------------
a | b | c
=============
能不能设计这样一个试图?
---
V
---
a
b
c
===
?
[解决办法]
create view v_a as
select f1 V from t union all select f2 from t union all select f3 from t