how to write sql query this below format output

Question

1.00/5 (3 votes)

See more:

Hi,

Table name accountmaster

I need your advice to get below output , I am using five tables using join to get this similar output. It's based on type and classification.
give some samples.

Is this possible to get following output.
kindly explain me.

|account no	type	classification	   branch code	  facility code		total |
|------------------------------------------------------------------------------------- 
|101	Site issue	Page not found	        BR1	        FC1
|285	Site issue	Page not found	        BR2	        FC2	           2
------------------------------------------------------------------------------------- |
|187	Browser issue	Compatability loading	BR1		FC2	           3  
|512	Browser issue	Compatability loading	BR1		FC2	
|303	Browser issue	Compatability loading	BR2		FC2			|
--------------------------------------------------------------------------------------

Posted 5-Aug-15 3:48am

Member 11887439

Add a Solution

Comments

[no name] 5-Aug-15 10:05am

What advice did you get the last time you post this exact same posting?

j snooze 5-Aug-15 17:09pm

Sometimes I am amazed at the "quality" of questions posted here. Asking for help saying there are 5 tables to join and you give us 1 table name? Also output that tells us nothing of what you are trying to accomplish or what data is in the tables. Is that total column an aggregate(sum, count, avg)? Please think before posting that the people you want help from do NOT know what is on your computer screen, what you are trying to do and what you have already tried unsuccessfully.

Aravindba 5-Aug-15 22:03pm

You are using 5 tables with join and get result,then why u ask question here ? what else u want ? u need more join query samples ?
try this link https://www.google.com/#q=join+in+slq

"Is this possible to get following output." form where ?
I am using five tables using join to get this similar output" i think like this
"I am using five tables and using join query need to get this similar output" ,is it correct ? then show u 5 tables and its data.
Ask you question clearly and provide related data.

1 solution

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)

barneyman · Answer 1 · 2015-08-05T15:45:00

Solution 1

as snooze said, you're not really helping us help you ... that said, i'd surmise that you're trying to build a webpage from data

have a look at SELECT ... FOR XML[^] and Converting XML to HTML with XSLT[^]

Posted 5-Aug-15 15:45pm

barneyman