sql join on Ó÷¨
A left join B µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëA±íµÄ¼Ç¼Êýͬ
A right join B µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëB±íµÄ¼Ç¼Êýͬ
A left join B µÈ¼ÛB right join A
table A:Field_K, Field_A1 a3 b4 ctable B:Field_K, Field_B1 x2 y4 zselect a.Field_K, a.Field_A, b.Field_K, b.Field_B from a left join b on a.Field_K=b.Field_KField_K Field_A Field_K Field_B ---------- ---------- ---------- ---------- 1 a 1 x 3 b NULL NULL4 c 4 z Ò²¾ÍÊÇ˵left join ÔòÁ¬½Ó×ó±ß±íÖÐËùÓмǼ¶¼»á³öÏÖ£¬Èç¹û¸ù¾ÝÁ¬½ÓÌõ¼þÔÚtable2ÖÐÕÒ²»µ½Ïà¹Ø¼Ç¼£¬ÔòÏÔʾΪnull¡£right join ÔòÏÔʾÓұ߱íÖеÄÈ«²¿¼Ç¼¡£inner join ÔòÖ»ÓзûºÏÌõ¼þµÄ¼Ç¼²Å»á³öÏÖÔÚ½á¹û¼¯ÖС£
EG2¡ÃÓÐÁ½±íaºÍb£¬Ç°Á½×Ö¶ÎÍêÈ«Ïàͬ£º(id int,name varchar(10)...)id name ----------- ---------- 1 a 2 b 3 cÒÔϵIJéѯÓï¾ä£¬ÄãÖªµÀËüµÄÔËÐнá¹ûÂ𣿣º1.select * from a left join b on a.id=b.id where a.id=12.select * from a left join b on a.id=b.id and a.id=13.select * from a left join b on a.id=b.id and b.id=14.select * from a left join b on a.id=1½á¹û:id name id name ----------- ----------- ----------- ----------- 1 10 1 10(1 row(s) affected) id name id name ----------- ----------- ----------- ----------- 1 10 1
Ïà¹ØÎĵµ£º
selectÓï¾äÖÐÖ»ÄÜʹÓÃsqlº¯Êý¶Ô×ֶνøÐвÙ×÷£¨Á´½Ósql server£©£¬
select ×Ö¶Î1 from ±í1 where ×Ö¶Î1.IndexOf("ÔÆ")=1;
ÕâÌõÓï¾ä²»¶ÔµÄÔÒòÊÇindexof£¨£©º¯Êý²»ÊÇsqlº¯Êý£¬¸Ä³Ésql¶ÔÓ¦µÄº¯Êý¾Í¿ÉÒÔÁË¡£
left£¨£©ÊÇsqlº¯Êý¡£
select ×Ö¶Î1 from ±í1 where charindex£¨'ÔÆ',×Ö¶Î1£©=1;
×Ö·û´®º¯Êý¶Ô¶þ½øÖÆÊý¾Ý¡¢×Ö·û´ ......
(ËÄ)ÆäËûÊéÉÏûÓеÄË÷ÒýʹÓþÑé×ܽá
¡¡¡¡1¡¢ÓþۺÏË÷Òý±ÈÓò»ÊǾۺÏË÷ÒýµÄÖ÷¼üËٶȿì
¡¡¡¡ÏÂÃæÊÇʵÀýÓï¾ä£º(¶¼ÊÇÌáÈ¡25ÍòÌõÊý¾Ý)
¡¡¡¡select gid,fariqi,neibuyonghu,reader,title from Tgongwen
¡¡¡¡where fariqi='2004-9-16'
¡¡¡¡Ê¹ÓÃʱ¼ä£º3326ºÁÃë
¡¡¡¡select gid,fariqi,neibuyonghu,reader,title from Tgongwe ......
¶þ¡¢¸ÄÉÆSQLÓï¾ä
¡¡¡¡ºÜ¶àÈ˲»ÖªµÀSQLÓï¾äÔÚSQL SERVERÖÐÊÇÈçºÎÖ´Ðеģ¬ËûÃǵ£ÐÄ×Ô¼ºËùдµÄSQLÓï¾ä»á±»SQL SERVERÎó½â¡£±ÈÈ磺
¡¡¡¡select * from table1 where name='zhangsan' and tID > 10000
¡¡¡¡ºÍÖ´ÐÐ:
¡¡¡¡select * from table1 where tID > 10000 and name='zhangsan'
¡¡¡¡Ò»Ð©È˲»ÖªµÀÒÔÉÏÁ½ÌõÓ ......
±í½á¹¹ÈçÏÂ:
id int 4
EntryID int 4
BlogID int 4
ÏÖÔÚÒªÇóÔÚ²åÈëʱ£¬²»ÔÊÐí²åÈëEntryIDÓëBlogID¶¼ÏàͬµÄ¼Ç¼£¬¼´±íÖв»ÔÊÐíÈÎÒâÁ½Ìõ¼Ç¼µÄEntryIDÓëBlogID¶¼Ïàͬ£¬EntryIDÓëBlogID¹¹³É¼Ç¼µÄΨһ±êʶ¡£
ÒÔÇ ......
sqlÓï¾ä´óÈ«:³£Óà SQL Óï¾ä´óÈ«
¡¡¡¡Óï ¾ä ¹¦ ÄÜ
¡¡¡¡--Êý¾Ý²Ù×÷
¡¡¡¡SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
¡¡¡¡INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
¡¡¡¡DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
¡¡¡¡UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
¡¡¡¡--Êý¾Ý¶¨Òå
¡¡¡¡CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
¡¡¡¡DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í ......