下面提到的sql查询之间的区别 [英] Difference between the sql queries mention below

问题描述

下面提到的两个查询之间有区别吗?
因为我找不到任何区别.
因此，请让我知道这些查询之间是否有任何区别..

 选择 * 来自 TBL_CLIENT   c
内部 加入 dbo.TBL_PROJECT  as  p 在上c.CLIENT_ID = p.CLIENT_ID
和 c.CLIENT_ID = 4

选择 * 来自 TBL_CLIENT  as  c
内部 加入 dbo.TBL_PROJECT  as  p <在上打开span class ="code-keyword"> c.CLIENT_ID = p.CLIENT_ID
其中 c.CLIENT_ID = 4 

在逻辑上，甚至从字面上看，给定的两个查询之间没有区别.确切的问题是什么?

Is there any difference between below two queries mention?
because I''m not able to find any difference.
Hence please lemme know if there is any difference between these queries..

select * from TBL_CLIENT as c
inner join dbo.TBL_PROJECT as p on c.CLIENT_ID=p.CLIENT_ID
and c.CLIENT_ID=4

select * from TBL_CLIENT as c
inner join dbo.TBL_PROJECT as p on c.CLIENT_ID=p.CLIENT_ID
where c.CLIENT_ID=4

Thanks

解决方案

Logically and even literally, there is no difference between the given two queries. What is the exact problem?

这篇关于下面提到的sql查询之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！