SQL query help

[usauae]

Hello sql gurus. Can you please help me with building a query. 
tables:

employee(empid, fname, lname)

manager(empid, managerid, deptid)

Director(empid, dirid,...)

now I would like to get results as 

empfname, emplname, ismanager, isdirector

how do I get that ? 

[NiranjanGaaru]

@Hydrockers

[pandemkodi]

Did u try anything ? 

[Spartan]

SELECT
Field1, Field2, Field3
FROM Table1
UNION
SELECT
Field1, Field2, Field3
FROM Table2
UNION
SELECT
Field1, Field2, Field3
FROM Table3

 

[Patient31Covid19]

6 minutes ago, usauae said:

Hello sql gurus. Can you please help me with building a query. 
tables:

employee(empid, fname, lname)

manager(empid, managerid, deptid)

Director(empid, dirid,...)

now I would like to get results as 

empfname, emplname, ismanager, isdirector

how do I get that ? 

select e.fname,e.lname,m.managerid,d.dirid from employee e, manager m,Director d where e.empid=m.empid and m.empid=d.epid

jst tried ready to crrct if missng long time tried sql

[naughty15]

select distinct a.fname, a.lname,

case when m.empid is null then 0 else 1 end as IsManager,

case when d.empid is null then 0 else 1 end as IsDirector

from employee a left outer join manager m on a.empid=m.empid left outer join director d on a.empid=d.empid

 

NOTe: NOT TESTED

[yemdoing]

1 minute ago, Spartan said:

SELECT
Field1, Field2, Field3
FROM Table1
UNION
SELECT
Field1, Field2, Field3
FROM Table2
UNION
SELECT
Field1, Field2, Field3
FROM Table3

 

 

 

[RajNeethi]

4 minutes ago, Spartan said:

SELECT
Field1, Field2, Field3
FROM Table1
UNION
SELECT
Field1, Field2, Field3
FROM Table2
UNION
SELECT
Field1, Field2, Field3
FROM Table3

 

[Spartan]

3 minutes ago, yemdoing said:

 

 

[Spartan]

1 minute ago, RajNeethi said:

[Anti_Sai]

11 minutes ago, usauae said:

Hello sql gurus. Can you please help me with building a query. 
tables:

employee(empid, fname, lname)

manager(empid, managerid, deptid)

Director(empid, dirid,...)

now I would like to get results as 

empfname, emplname, ismanager, isdirector

how do I get that ? 

select 

e.empfname, e.emplname, m.ismanager, d.isdirector

from

employee e

left join manager m on

e.empid = m.empid

left join director d on

e.empid = d.empid

[usauae]

8 minutes ago, naughty15 said:

select distinct a.fname, a.lname,

case when m.empid is null then 0 else 1 end as IsManager,

case when d.empid is null then 0 else 1 end as IsDirector

from employee a left outer join manager m on a.empid=m.empid left outer join director d on a.empid=d.empid

 

NOTe: NOT TESTED

Super bro it worked. 
case statement ila kuda use chesukovachhu ani teleyaledu.

inkoka help if you don’t mind. Ee query tho I get

empid1, 0,0

empid2, 1,0

so can I apply a filter to not show 0?

[RajNeethi]

Just now, usauae said:

Super bro it worked. 
case statement ila kuda use chesukovachhu ani teleyaledu.

inkoka help if you don’t mind. Ee query tho I get

empid1, 0,0

empid2, 1,0

so can I apply a filter to not show 0?

 ni alpasantosham thagaleyya... 

[yemdoing]

1 minute ago, usauae said:

Super bro it worked. 
case statement ila kuda use chesukovachhu ani teleyaledu.

inkoka help if you don’t mind. Ee query tho I get

empid1, 0,0

empid2, 1,0

so can I apply a filter to not show 0?

CTE use chesi apply or nested SQL use chesi apply cheyacchu.

 

[yemdoing]

Just now, RajNeethi said:

 ni alpasantosham thagaleyya... 

encourage man... he might he tope in other techs.

if I write hello world in Python I would feel so happy.