sqlÓï¾äÖÐleft join¡¢inner joinÖеÄonÓëwhereµÄÇø±ð
table a(id, type):
id type
----------------------------------
1 1
2 1
3 2
table b(id, class):
id class
---------------------------------
1 1
2 2
sqlÓï¾ä1£ºselect a.*, b.* from a left join b on a.id = b.id and a.type = 1;
sqlÓï¾ä2£ºselect a.*, b.* from a left join b on a.id = b.id where a.type = 1;
sqlÓï¾ä3£ºselect a.*, b.* from a left join b on a.id = b.id and b.class = 1;
sqlÓï¾ä1µÄÖ´Ðнá¹ûΪ£º
a.id a.type b.id b.class
----------------------------------------
1 1 1 1
2 1 2 2
3 2
sqlÓï¾ä2µÄÖ´Ðнá¹ûΪ£º
a.id a.type b.id b.class
----------------------------------------
1 1 1 1
2 1 2 2
sqlÓï¾ä3µÄÖ´Ðнá¹ûΪ£º
a.id a.type b.id b.class
----------------------------------------
1 &n
Ïà¹ØÎĵµ£º
OracleÖг£ÓõÄÃüÁîºÍº¯Êý£¬×ö¸öÕûÀí£¬ÒÔ±¸ÒÔºóÓõ½£¬·½±ã²éÔÄ¡£
³£ÓÃÃüÁ
Á¬½Ósqlplus
ÃüÁîÐÐÏÂÔËÐÐcmd½øÈ룬ÈçÒÔsysģʽµÇ½£¬ÃüÁîÈçÏ£º
(1).sqlplus "sys/zhb126 as sysdba"
(2).sqlplus/nolog connect sys/zhb126 as sysdba
(3).sqlplus scott ......
Ç°²»¾Ã¿´µ½Í¬ÊÂÔÚÓÃSql Prompt3.9£¬¾õµÃÂù·½±ãµÄ¡£¸øÎÒÃÇд³ÌÐòÄÜʡϲ»ÉÙÁ¦Æø¡£·½±ã£¬sql´úÂë¿´ÆðÀ´ÓÖ¼ò½é¡£ÖµµÃÍƼö¡£http://www.red-gate.com/ÕâÊÇËüµÄ¹ÙÍø£¬ÊÇÒ»¿îÊշѵÄÈí¼þ¡£Õýʽ°æ±¾ÏÂÔØÏÂÀ´Ö»ÄÜʹÓÃ14Ìì¡£·Ï»°²»ËµÁË£¬ÏÈ¿´ÏÂЧ¹ûͼ£º
»¹²»´í°¡¡£
½ÓÏÂÀ´½éÉÜÏÂÆƽâµÄ·½·¨£¬Ïȵ½¹ÙÍø°Ñ×îаæ(ÏÖÔÚÒѾÊÇ3.9ÁË)ÏÂÏÂÀ ......