SQL join and where clause doubt

Question

0.00/5 (No votes)

See more:

SQL

ALTER PROC [dbo].[GET_PDFEXPORT](@ENT_NUM as varchar(10))
as
select a.Enterprise_number,a.Name,b.Report_Type as Report,b.Red_Flag as FileType, c.Link as SEC_LINK from T_CompanyFinancial a
join T_Tracking b on a.Enterprise_number=b.Enterprise_number
join T_Allocation c on a.Enterprise_number=c.Enterprise_Number
where a.Enterprise_number=@ENT_NUM

hi from above query i have following doubt

I need link from t_allocation table so there is need to use join here
but same time all the Enterprise_number from T_CompanyFinancial not presented in table T_allocation
if Enterprise_number is not present in T_allocation means sec_link can be blank

HOw can do this

Help me thanks

Posted 28-Feb-13 19:56pm

kimberly wind

Add a Solution

3 solutions

Solution 3

Hi,

Refer the following Links for SQL JOIN

SQL SERVER – Introduction to JOINs – Basic of JOINs[^]

SQL Server Join Example[^]

Different Types of SQL Joins[^]

SQL SERVER JOINs[^]

Regards,
GVPrabu

Posted 28-Feb-13 20:19pm

gvprabu

Updated 28-Feb-13 20:20pm

v3

Comments

kimberly wind 1-Mar-13 2:35am

Hi thanks for the link

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prakash Thirumoorthy · Accepted Answer · 2013-02-28T20:09:00

Solution 1

hi,
you can use left join query. it may help you,

SQL

SELECT a.Enterprise_number,a.Name,b.Report_Type as Report,b.Red_Flag as FileType, c.Link as SEC_LINK 
FROM T_CompanyFinancial a
INNER JOIN T_Tracking b on a.Enterprise_number=b.Enterprise_number
LEFT OUTER JOIN T_Allocation c on a.Enterprise_number=c.Enterprise_Number
WHERE a.Enterprise_number=@ENT_NUM

regards,
Prakash.T

Posted 28-Feb-13 20:09pm

Prakash Thirumoorthy

Updated 21-Mar-13 20:45pm

v2

Comments

kimberly wind 1-Mar-13 2:21am

Hi i tried but now its taking Enterprise number from t_allocation table which is not present in
T_CompanyFinancial

kimberly wind 1-Mar-13 2:27am

thanks it works good :)

kimberly wind 1-Mar-13 2:28am

my 5

*Karthik Harve* · Accepted Answer · 2013-02-28T20:12:00

Solution 2

Hi,

try with OUTER JOIN for T_Allocation table.

SQL

select a.Enterprise_number,a.Name,b.Report_Type as Report,b.Red_Flag as FileType, c.Link as SEC_LINK from T_CompanyFinancial a
join T_Tracking b on a.Enterprise_number=b.Enterprise_number
LEFT OUTER join T_Allocation c on a.Enterprise_number=c.Enterprise_Number
where a.Enterprise_number=@ENT_NUM

hope it helps

Posted 28-Feb-13 20:12pm

Karthik Harve

Comments

kimberly wind 1-Mar-13 2:21am

Hi i tried but now its taking Enterprise number from t_allocation table which is not present in
T_CompanyFinancial

kimberly wind 1-Mar-13 2:28am

its correct and thanks it works 5n my 5

Karthik Harve 1-Mar-13 2:32am

Welcome. and Happy coding :-)