how to fetch data from different table

Question

0.00/5 (No votes)

See more:

Dear Friend,

i am facing problem when impliments query. i have two table name as dept and emp.dept attributes are deptid,deptname and emp attributes are empid,empname,deptid.you got in deptid is foreign key of dept table or entity.

i had inserted data in dept table just like

deptid  deptname

1       hr
2       .net

i had inserted data in emp table just like

empid  empname  deptid
1      ashwini  1
2      harshal  2
3      shital   1
4      ganpat   2
5      smita    1

i have retrieve data from both table just like

hr
.net
hr
ashiwini
shital
smita
.net
harshal
ganpat.

Did you get in. i want to fetch data firstly by deptname from dept table then later i fetch data from
both table dept and emp but as per group of dept.

its so much complicated to solve this query.please give me some suggestion or information how to get me
this type of output.

thanks in advanced !!

Posted 24-Jan-15 0:28am

Member 8089110

Updated 24-Jan-15 0:40am

User 11060979

v2

Add a Solution

Comments

[no name] 24-Jan-15 6:47am

No I did not get in....but maybe you can play with something like this
SELECT X,Y,Z
FROM DEPT
LEFT JOIN EMP ON EMP.DEPTID = DEPT.DEPTID
WHERE whatever you need

Member 8089110 24-Jan-15 7:11am

i want to get in data just like first retrieve deptname then later group wise means first deptname then empname who is member of particular dept then another deptname ,empname who is member of that dept ...

3 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)

King Fisher · Answer 1 · 2015-01-24T00:45:00

Solution 1

use joins to achieve this:

http://www.tutorialspoint.com/mysql/mysql-using-joins.htm[^]

Posted 24-Jan-15 0:45am

King Fisher

Peter Leow · Answer 2 · 2015-01-24T02:57:00

Solution 2

Try this:

select empname, deptname from employee e join department d on e.deptid=d.deptid order by deptname

Posted 24-Jan-15 2:57am

Peter Leow

Wendelius · Answer 3 · 2015-01-24T04:02:00

Not sure if I understood your question correctly but if the amount of departments is fixed then you can try something like

SQL

select 1, dept_name from dept
union all
select 2, dept_name from dept where dept_name = 'hr'
union all
select 3, emp_name  from emp  where dept_name = 'hr'
union all
select 4, dept_name from dept where dept_name = '.net'
union all
select 5, emp_name  from emp  where dept_name = '.net'
order by 1, 2

If the amount of departments isn't fixed I suggest using a table valued function. For example, see Using Table-Valued Functions in SQL Server[^]