Problem in Left Joining

Question

0.00/5 (No votes)

See more:

hi i used left join between to tables n my prob is when the left table doesn't find data in the right it shows NULL . I want that it wouldn't show any thing i mean the NULL word will not be there rather a blank cell. I mean it looks really ugly seeing the word NULL. Somebody please help.

Posted 30-Aug-11 8:51am

Ehtesam Ahmed

Add a Solution

Comments

Yogesh Pednekar 30-Aug-11 15:10pm

show me your query
Expected result
And result that you are getting.

4 solutions

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)

Espen Harlinn · Answer 1 · 2011-08-30T09:42:00

Solution 2

Take a look at:
ISNULL (Transact-SQL)[^]

You can use this to convert the NULL to '' - an empty string. You may need to use CAST or CONVERT[^] if the column is not a string or char type.

Best regards
Espen Harlinn

Posted 30-Aug-11 9:42am

Espen Harlinn

sachin10d · Answer 2 · 2011-08-31T00:35:00

Solution 3

SQL

select isnull([column name],'') from [TableName]

Posted 31-Aug-11 0:35am

sachin10d

Updated 31-Aug-11 0:37am

v3

BobJanova · Answer 3 · 2011-08-31T00:47:00

Those values should be null (there is no value there). The UI control you use to display the result should do something sensible with it. You tagged the question C# – as far as I know the standard controls (DataGridView or DataGrid) already do that.

Don't worry about what it looks like in a database query result window, the purpose of that is not to look pretty.

Simon Bang Terkildsen · Answer 4 · 2011-08-30T08:56:00

Solution 1

Use INNER JOIN instead of LEFT JOIN

This article might help you in the future
Visual Representation of SQL Joins[^]

Posted 30-Aug-11 8:56am

Simon Bang Terkildsen

Comments

BobJanova 31-Aug-11 6:45am

An inner join will remove that row entirely. That's not what the question is asking for.

Simon Bang Terkildsen 31-Aug-11 9:11am

True, I seem to have missread the question. But no harm done, others have given an acceptable answer :)