join query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

join query

Author

Topic

nikoo56
Starting Member

26 Posts

Posted - 2011-10-21 : 13:44:46

I have this query:

select *

from tblC5ProspectCalls c (nolock)

inner join tblC5ProspectCallResultChoices cc (nolock) on c.call_result_id = cc.call_result_id

where call_result != 'c4 initial' and call_result='tt'

I would like to join with this query:

select * from vwInternetProspects3

both have prospectID common. I am not sure how to so that? Can you please help me.

I really appriciate your help.

Thanks,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-21 : 13:55:03

[code]select *

from tblC5ProspectCalls c (nolock)

inner join tblC5ProspectCallResultChoices cc (nolock) on c.call_result_id = cc.call_result_id
inner join vwInternetProspects3 p3 on p3.prospectID = c.prospectID
where call_result != 'c4 initial' and call_result='tt'
[/code]
i assume you understand the problems associated with nolock usage
if not read this

http://visakhm.blogspot.com/2010/02/avoiding-deadlocks-using-new.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources