Click here to Skip to main content
15,031,219 members
Please Sign up or sign in to vote.
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
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

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[^]
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900