I wabt to join 5 views together which all have one column same:
view1
a1 xxx ccccc
a2 zxc fdgdfsd
a3 cvf fdgdfggfgf
view2
a1 cvnnbn dhgfhgf
a2 ghjghjjgggggg
a3 nnnngg ffffffffssdf
view3
a1vvvvvvgggggg
a2bbbbbbjjjjjjjjjjjjjjjjj
a3yyyyyyyjkjhkhjkhj
...........
How to join these 5 views together with sql statement?