Styjun

What ways have you found to get edits from non-LaTeX users?

Extreme flexible working hours: how to control people and activities?

I have a problem assistant manager, but I can't fire him

Can Rydberg constant be in joules?

Overlapping String-Blocks

Arriving at the same result with the opposite hypotheses

How do governments keep track of their issued currency?

English word for "product of tinkering"

Implement Own Vector Class in C++

Why didn't Voldemort recognize that Dumbledore was affected by his curse?

Why do some employees fill out a W-4 and some don't?

Which languages would be most useful in Europe at the end of the 19th century?

You have (3^2 + 2^3 + 2^2) Guesses Left. Figure out the Last one

Fixing obscure 8080 emulator bug?

Rebus with 20 song titles

How can I get an unreasonable manager to approve time off?

What speaks against investing in precious metals?

How is John Wick 3 a 15 certificate?

Why we don’t make use of the t-distribution for constructing a confidence interval for a proportion?

How to safely destroy (a large quantity of) valid checks?

Are there any important biographies of nobodies?

Cascading Switches. Will it affect performance?

A IP can traceroute to it, but can not ping

How come the nude protesters were not arrested?

How use the value of one column to check the values of another row?

How can I prevent SQL injection in PHP?How do you set a default value for a MySQL Datetime column?Can I concatenate multiple MySQL rows into one field?How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?SQL select only rows with max value on a columnHow to import an SQL file using the command line in MySQL?SQL- Using a value in one tuple to get a value from another oneQuery to display from multiple tablesHow do I generate a MySQL view such that it show all objects in your heircachyHow can I show that someone is part of a shift that they supervise?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have to create a view that shows employee information for employees who are supervised by female supervisors. I have to display EMP_NUM, EMP_TITLE, EMP_FNAME, EMP_LNAME, and the manager’s employee number,
last name, and title.

The code that I tried only gives me the manager information for Lewis.

Below is a picture of the table EMP.
empTable

CREATE VIEW empSalary AS 
 SELECT EMP_NUM007, EMP_TITLE, EMP_FNAME, EMP_LNAME, EMP_MGR, 
 (SELECT EMP_LNAME FROM EMP WHERE EMP_NUM007 = EMP_MGR), 
 (SELECT EMP_TITLE FROM EMP WHERE EMP_NUM007 = EMP_MGR) 
 FROM EMP 
 GROUP BY EMP_NUM007;

mysql view

share|improve this question

edited Mar 24 at 18:47

forpas

28k4930

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

add a comment | 

0

I have to create a view that shows employee information for employees who are supervised by female supervisors. I have to display EMP_NUM, EMP_TITLE, EMP_FNAME, EMP_LNAME, and the manager’s employee number,
last name, and title.

The code that I tried only gives me the manager information for Lewis.

Below is a picture of the table EMP.
empTable

CREATE VIEW empSalary AS 
 SELECT EMP_NUM007, EMP_TITLE, EMP_FNAME, EMP_LNAME, EMP_MGR, 
 (SELECT EMP_LNAME FROM EMP WHERE EMP_NUM007 = EMP_MGR), 
 (SELECT EMP_TITLE FROM EMP WHERE EMP_NUM007 = EMP_MGR) 
 FROM EMP 
 GROUP BY EMP_NUM007;

mysql view

share|improve this question

edited Mar 24 at 18:47

forpas

28k4930

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

add a comment | 

I have to create a view that shows employee information for employees who are supervised by female supervisors. I have to display EMP_NUM, EMP_TITLE, EMP_FNAME, EMP_LNAME, and the manager’s employee number,
last name, and title.

The code that I tried only gives me the manager information for Lewis.

Below is a picture of the table EMP.
empTable

CREATE VIEW empSalary AS 
 SELECT EMP_NUM007, EMP_TITLE, EMP_FNAME, EMP_LNAME, EMP_MGR, 
 (SELECT EMP_LNAME FROM EMP WHERE EMP_NUM007 = EMP_MGR), 
 (SELECT EMP_TITLE FROM EMP WHERE EMP_NUM007 = EMP_MGR) 
 FROM EMP 
 GROUP BY EMP_NUM007;

mysql view

share|improve this question

edited Mar 24 at 18:47

forpas

28k4930

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

CREATE VIEW empSalary AS 
 SELECT EMP_NUM007, EMP_TITLE, EMP_FNAME, EMP_LNAME, EMP_MGR, 
 (SELECT EMP_LNAME FROM EMP WHERE EMP_NUM007 = EMP_MGR), 
 (SELECT EMP_TITLE FROM EMP WHERE EMP_NUM007 = EMP_MGR) 
 FROM EMP 
 GROUP BY EMP_NUM007;

share|improve this question

edited Mar 24 at 18:47

forpas

28k4930

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

share|improve this question

edited Mar 24 at 18:47

forpas

28k4930

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

edited Mar 24 at 18:47

forpas

28k4930

edited Mar 24 at 18:47

forpas

28k4930

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

asked Mar 24 at 18:28

avaaaaalynavaaaaalyn

1

1 Answer
1

active

oldest

votes

0

You need a self join on the table:

select 
 e.emp_num, e.emp_title, e.emp_fname, e,emp_lname,
 m.emp_num, m.emp_title, m.emp_fname, m.emp_lname 
from emp e inner join emp m
on m.emp_num007 = e.emp_mgr
where m.emp_title = 'Mrs.'

share|improve this answer

answered Mar 24 at 18:53

forpasforpas

28k4930

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55327081%2fhow-use-the-value-of-one-column-to-check-the-values-of-another-row%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You need a self join on the table:

select 
 e.emp_num, e.emp_title, e.emp_fname, e,emp_lname,
 m.emp_num, m.emp_title, m.emp_fname, m.emp_lname 
from emp e inner join emp m
on m.emp_num007 = e.emp_mgr
where m.emp_title = 'Mrs.'

share|improve this answer

answered Mar 24 at 18:53

forpasforpas

28k4930

add a comment | 

0

You need a self join on the table:

select 
 e.emp_num, e.emp_title, e.emp_fname, e,emp_lname,
 m.emp_num, m.emp_title, m.emp_fname, m.emp_lname 
from emp e inner join emp m
on m.emp_num007 = e.emp_mgr
where m.emp_title = 'Mrs.'

share|improve this answer

answered Mar 24 at 18:53

forpasforpas

28k4930

add a comment | 

You need a self join on the table:

select 
 e.emp_num, e.emp_title, e.emp_fname, e,emp_lname,
 m.emp_num, m.emp_title, m.emp_fname, m.emp_lname 
from emp e inner join emp m
on m.emp_num007 = e.emp_mgr
where m.emp_title = 'Mrs.'

share|improve this answer

answered Mar 24 at 18:53

forpasforpas

28k4930

select 
 e.emp_num, e.emp_title, e.emp_fname, e,emp_lname,
 m.emp_num, m.emp_title, m.emp_fname, m.emp_lname 
from emp e inner join emp m
on m.emp_num007 = e.emp_mgr
where m.emp_title = 'Mrs.'

share|improve this answer

answered Mar 24 at 18:53

forpasforpas

28k4930

answered Mar 24 at 18:53

forpasforpas

28k4930

answered Mar 24 at 18:53

forpasforpas

28k4930