sql2005加入问题 [英] sql2005 join problem
本文介绍了sql2005加入问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
我有两个表,其中有一个要联接;
我需要第一张桌子的独立部分;
请帮助我
Hi
I have two tables that they have one fild to join;
I need independence part of first table;
plz help me
推荐答案
:doh:
您没有阅读或浏览过昨天与您共享的链接 [^ ],对吧?
如果是INNER JOIN,则类似于:
:doh:
You did not read or went through the links shared with you yesterday[^], right?
If it''s a INNER JOIN, it would be something like:
SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.commonfield = table2.commonfield
试试吧!
Try!
嗨 您可以对第一个表使用特殊的声明,即那些记录在那里''nt
在另一个桌子上
hi u can use the special asertion for first table that those records there''nt
at the another table
这篇关于sql2005加入问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文