MySql join multiple select subquery

Question

-SOLUTION-

SELECT Table1.unvan, Table2.sayi FROM 
(SELECT id , unvan FROM unvan WHERE id IN 
(SELECT unvani FROM personel WHERE gorev_yeri IN 
(SELECT id FROM gorev_yeri WHERE il_id="34") ) ) AS Table1 
JOIN
( SELECT unvani as id , count(*) AS sayi FROM personel WHERE gorev_yeri IN (SELECT id FROM gorev_yeri WHERE il_id="34") GROUP BY unvani ) AS Table2 
ON Table1.id = Table2.id

-EDIT-

When I use join with as I get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS table1

I have 2 query and I want join them.

It is first.

SELECT id
     , unvan 
  FROM unvan 
 WHERE id IN (SELECT unvani 
                FROM personel 
               WHERE gorev_yeri IN (SELECT id 
                                      FROM gorev_yeri 
                                     WHERE il_id="34")
              )

It is second one.

SELECT unvani as id
     , count(*) AS sayi 
 FROM personel 
WHERE gorev_yeri IN (SELECT id 
                       FROM gorev_yeri 
                        WHERE il_id="34") GROUP BY unvani

I need this:

unvan|sayi

--------|----

See: Why should I provide an MCVE for what seems to me to be a very simple SQL query? — Strawberry
– Strawberry, Commented Jun 7, 2017 at 11:20
Add some sample results from the two queries, and show us the combined result. (Well formatted text, please.) — jarlh
– jarlh, Commented Jun 7, 2017 at 11:22
Thanks for underestimate me about join. When I use join i get error like this : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table1. — Circas Creed
– Circas Creed, Commented Jun 7, 2017 at 11:28

Kruti Patel · Accepted Answer · 2017-06-08 04:25:33Z

2

Based from error provided

It should be like this:

SELECT `Table1`.unvan, `Table2`.id
FROM
(
    SELECT id
    , unvan 
   FROM unvan 
   WHERE id IN (SELECT unvani 
            FROM personel 
           WHERE gorev_yeri IN (SELECT id 
                                  FROM gorev_yeri 
                                 WHERE il_id="34")
          )
) AS `Table1`

JOIN

(
SELECT unvani as id
 , count(*) AS sayi 
 FROM personel 
 WHERE gorev_yeri IN (SELECT id 
                   FROM gorev_yeri 
                    WHERE il_id="34") GROUP BY unvani
) AS `Table2`

ON `Table1`.id = `Table2`.id

edited Jun 8, 2017 at 4:25

Kruti Patel

1,4722 gold badges24 silver badges37 bronze badges

answered Jun 7, 2017 at 12:58

jmai

943 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user8084576 · Accepted Answer · 2017-06-07 11:24:35Z

1

(SELECT id , unvan FROM unvan WHERE id IN (SELECT unvani FROM personel WHERE gorev_yeri IN (SELECT id FROM gorev_yeri WHERE il_id="34") ) )table1

join

( SELECT unvani as id, count(*) AS sayi FROM personel WHERE gorev_yeri IN (SELECT id FROM gorev_yeri WHERE il_id="34") GROUP BY unvani )table2

on table1.id=table2.id;

answered Jun 7, 2017 at 11:24

user8084576

4 Comments

Circas Creed Over a year ago

When I use join i get error like this : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table1.

jarlh Over a year ago

Add SELECT * FROM first of all. And, perhaps you need to do as table1.

user8084576 Over a year ago

Yeah, sorry I forgot, Add Select * from

Circas Creed Over a year ago

Same error again : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS table1

Collectives™ on Stack Overflow

MySql join multiple select subquery

-EDIT-

When I use join with as I get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS table1

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

-EDIT-

When I use join with as I get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS table1

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related