sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

---

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈ磺key=request.form("key") 
set rs=server.createobject("adodb.recordset")
sql = "select * from toutiao where title like '%"&key& "%' or content like '%"&key& "%' "
sql = "select * from xinxi where title like '%"&key& "%' or content like '%"&key& "%' "
¡£¡£¡£¡£

¾ÍÊǽ«É϶à¸öSQL±ä³ÉÒ»¾ä

---

select * from (select name,content from A union all select name,content from B union all select name,content from C) where name like '%Öйú%' or content like '%Öйú%'

---

select A.name, A.content, B.name, B.content, C.name, C.content from A,B,C where name like '%Öйú%' or content like '%Öйú%'

---

SQL code:

select * from a where name like '%Öйú%' or content like '%Öйú%'
union all
select * from b where name like '%Öйú%' or content like '%Öйú%'
union all
select * from c where name like '%Öйú%' or content like '%Öйú%'

---

¶¥Ò»¸ö£¡£¡