Hello friends,
I am using 2 tables, that are IT_Experts and IT_Category, The IT_Experts contains id, Name, email, consultskill1, consultskill3, consultskill3 and the IT_Category contains CatId, Catname, log. And i displyed the follwing query:
"Select e.Id,e.Name,c.CatName from IT_Experts e join IT_Category c
on c.CatId = e.consultskill1 order by e.Name"
And i want to display the 3 consultskills using the same Catname. what to do.
please send urs suggestions.......
|
| Author: greeny_1984 02 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
Hi,
You can use 'AS' to achieve your functionality in sql server
for ex:
select column1 as 'counsultskills' from table1
Regards,
Greeny_1984
Rate this Response[Excellent/Good/Poor]
FRESHERS check this link
Need help from me join here
|
| Author: Mohan 02 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Can you show the final output what you expect??
Regards
Mohan Kumar.D
|
| Author: ABitSmart 02 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Please provide some more details with sample data expected. But looks like you need to add a group by 'c.CatName' to your query
|