sql2005加入问题 [英] sql2005 join problem

问题描述

嗨
我有两个表，其中有一个要联接；

我需要第一张桌子的独立部分；

请帮助我

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屋！