SQL语句问题!!! ( 积分: 50 )

我现在要把:<br>SELECT&nbsp;userid,name,vt,vn,w808590,if_xs1&nbsp;FROM&nbsp;eta&nbsp;<br>where&nbsp;et_id&lt;'9100'&nbsp;&nbsp;and&nbsp;isnull(vt,'')&lt;&gt;''&nbsp;and&nbsp;tq_id&nbsp;like&nbsp;'z%'<br>Order&nbsp;by&nbsp;Userid<br>和<br>select&nbsp;userid,name,substring(zhuno,3,4)as&nbsp;&quot;zhuno&quot;&nbsp;from&nbsp;eta&nbsp;e,dprice&nbsp;d&nbsp;where&nbsp;e.typeid=d.typeid&nbsp;and&nbsp;e.et_id&nbsp;like&nbsp;'%010'&nbsp;and&nbsp;tq_id&nbsp;like&nbsp;'Z%'&nbsp;order&nbsp;by&nbsp;userid<br>写在一起,请问如何写?谢谢!!!为盼!!!

看不大懂，楼主能写清楚一点吗？

我要将userid,name,vt,vn,w808590,if_xs1&nbsp;,substring(zhuno,3,4)as&nbsp;&quot;zhuno&quot;字段用一句SQL语句写出来,如何写语句,主要是Where后面的条件不是相同的.

用union可以吗？

用union，但是查询内容得相同

把第2部分的构造补全为6个字段后union

spirit_day:你好！能帮忙写出来么，试验了多次写不好啊。。。[]

elect&nbsp;userid,name,substring(zhuno,3,4)as&nbsp;&quot;zhuno&quot;,c.vt,c.vn,c.w808590,if_xs1&nbsp;from&nbsp;eta&nbsp;e<br>inner&nbsp;join&nbsp;dprice&nbsp;d&nbsp;on&nbsp;e.typeid=d.typeid&nbsp;and&nbsp;e.et_id&nbsp;like&nbsp;'%010'&nbsp;and&nbsp;tq_id&nbsp;like&nbsp;'Z%'&nbsp;<br>inner&nbsp;join&nbsp;(SELECT&nbsp;userid,vt,vn,w808590,if_xs1&nbsp;FROM&nbsp;eta&nbsp;<br>where&nbsp;et_id&lt;'9100'&nbsp;&nbsp;and&nbsp;isnull(vt,'')&lt;&gt;''&nbsp;and&nbsp;tq_id&nbsp;like&nbsp;'z%')&nbsp;c&nbsp;on&nbsp;a.userid&nbsp;=&nbsp;c.userid<br>order&nbsp;by&nbsp;userid

谢谢了！！！缘分啊。。。