急求一个SQL查询？不知是否有这种可能SQL语句？感谢(50分)

急求一个SQL查询？不知是否有这种可能SQL语句？感谢<br>数据表如下：<br>&nbsp;字段1 字段2 字段3 字段4 <br>&nbsp;a1 &nbsp; &nbsp; 523 &nbsp; aa &nbsp; &nbsp;bb<br>&nbsp;a2 &nbsp; &nbsp; 34 &nbsp; &nbsp;aa &nbsp; &nbsp;bb<br>&nbsp;a3 &nbsp; &nbsp; 34 &nbsp; &nbsp;aa &nbsp; &nbsp;bb<br>&nbsp;a1 &nbsp; &nbsp; 24 &nbsp; &nbsp;bb &nbsp; &nbsp;cc<br>&nbsp;a2 &nbsp; &nbsp; 74 &nbsp; &nbsp;bb &nbsp; &nbsp;cc<br>&nbsp;a3 &nbsp; &nbsp; 856 &nbsp; bb &nbsp; &nbsp;cc<br>&nbsp;a1 &nbsp; &nbsp; 532 &nbsp; cc &nbsp; &nbsp;dd<br>&nbsp;a2 &nbsp; &nbsp; 36 &nbsp; &nbsp;cc &nbsp; &nbsp;dd<br>&nbsp;a3 &nbsp; &nbsp; 34 &nbsp; &nbsp;cc &nbsp; &nbsp;dd<br>这个表的记录还有可字段3的dd到字段4的EE，一真向下可以YY到ZZ<br>能不能用SQL语句查询得么如下结果：<br>&nbsp;a1 &nbsp; &nbsp; aa &nbsp;523 &nbsp; bb &nbsp; &nbsp;24 &nbsp; cc &nbsp;532 &nbsp;dd<br>&nbsp;a2 &nbsp; &nbsp; aa &nbsp;34 &nbsp; &nbsp;bb &nbsp; &nbsp;74 &nbsp; cc &nbsp;36 &nbsp; dd <br>&nbsp;a3 &nbsp; &nbsp; aa &nbsp;34 &nbsp; &nbsp;bb &nbsp; &nbsp;856 &nbsp;cc &nbsp;34 &nbsp; dd<br>感谢，

意思表达不清<br>阅

难解决，另相办法