谁能教教我这个SQL怎么写?

来源:百度知道 编辑:UC知道 时间:2024/04/30 01:34:32
一个SQL是这样的:

SQL = "SELECT * From Table1 Where Key1 = '10' Or Key2 = '10' Or Key3 = '10' Or Key4 = '10'"

都知道这样可以调用所有Key1=10或Key2=10或Key3=10或Key4=10的数据,但是我还想从中剔除Key5不等于20的数据,这个SQL代码该怎么写呢?

是不是应该从里面加入UNION,把几个SELECT串起来?

谁能教教我,急用啊!
看到很多网友解答,深感宽慰,但是好像都不能解决问题。因此进一步解释一下:

这是我的SQL,

Sql = "Select Top 5 ID,Video_Picture,Video_Tag1,Video_Tag2,Video_Tag3,Video_Title From Video Where Video_Tag1 = '"&rs1("Video_Tag1")&"' or Video_Tag1 = '"&rs1("Video_Tag2")&"' or Video_Tag1 = '"&rs1("Video_Tag3")&"' or Video_Tag2 = '"&rs1("Video_Tag1")&"' or Video_Tag2 = '"&rs1("Video_Tag2")&"' or Video_Tag2 = '"&rs1("Video_Tag3")&"' or Video_Tag3 = '"&rs1("Video_Tag1")&"' or Video_Tag3 = '"&rs1("

Sql = "Select Top 5 ID,Video_Picture,Video_Tag1,Video_Tag2,Video_Tag3,Video_Title From Video Where (Video_Tag1 = '"&rs1("Video_Tag1")&"' or Video_Tag1 = '"&rs1("Video_Tag2")&"' or Video_Tag1 = '"&rs1("Video_Tag3")&"' or Video_Tag2 = '"&rs1("Video_Tag1")&"' or Video_Tag2 = '"&rs1("Video_Tag2")&"' or Video_Tag2 = '"&rs1("Video_Tag3")&"' or Video_Tag3 = '"&rs1("Video_Tag1")&"' or Video_Tag3 = '"&rs1("Video_Tag2")&"' or Video_Tag3 = '"&rs1("Video_Tag3")&"') and ID="&rs1("ID")&" Order By Video_Times DESC,ID DESC "

如果上面不行的下面

Sql = "Select Top 5 ID,Video_Picture,Video_Tag1,Video_Tag2,Video_Tag3,Video_Title From Video Where (Video_Tag1 = '"&rs1("Video_Tag1")&"