查询转换 [英] query convertion

问题描述

朋友，请帮帮我.


我陷入了我的一项任务，即我想使用联合查询将联合查询转换为联接查询，并且我应该获得与联合查询相同的输出.请帮帮我！

Hi friends, please help me.


I got stuck in one of my tasks, i.e I want to convert a union query into join query using and I should get the same output as if in union query. Please help me!

union query

select distinct p1.people_id,p1.fullname,p1.company_id,c1.company_name,p1.city,p1.state,p1.country,p1.user_id from people p1,company c1 where c1.company_id=p1.company_id and p1.verify_status=''Yes'' and p1.royalty=''Yes'' and p1.user_id=''" + userID + "'' and p1.delete_status=''No'' union select p1.people_id,p1.fullname,p1.company_id,c1.company_name,p1.city,p1.state,p1.country,p1.user_id from BackupPeople p1,company c1 where c1.company_id=p1.company_id and p1.user_id=''" + userID + "''";

我想将其转换为具有相同输出的联接.

I want to convert it into join with same output.

推荐答案

SELECT DISTINCT p1.people_id,p1.fullname,p1.company_id,c1.company_name,p1.city,p1.state,p1.country,p1.user_id
FROM #people p1 INNER JOIN #company C1 ON c1.company_id=p1.company_id
                INNER JOIN #BackupPeople Bp1 ON c1.company_id=Bp1.company_id
WHERE
          p1.verify_status='Yes'
      AND p1.royalty='Yes'
      AND p1.user_id=1
      AND p1.delete_status='No'

这篇关于查询转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！