merge two query into one single query in sql

Question

In my file there is already one query name query1 and I write another query name query2. The o/p of both query is userid. Now I want to find the common userid from these two queries. So is there any function for that?

The array_intersect() function generates an error.

look this dba.stackexchange.com/questions/63506/…

Angel Angel
– Angel Angel

2014-12-23 05:55:30 +00:00
Commented Dec 23, 2014 at 5:55 — Angel Angel
– Angel Angel, Commented Dec 23, 2014 at 5:55

Barmar · Accepted Answer · 2014-12-23 06:03:02Z

1

Use a JOIN

$query1 = "SELECT userid FROM table1";
$query2 = "SELECT userid FROM table2 WHERE something = 10";
$joinQuery = "
    SELECT a.userid
    FROM ($query1) AS a
    JOIN ($query2) AS b
    ON a.userid = b.userid";

edited Dec 23, 2014 at 6:03

answered Dec 23, 2014 at 5:55

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

3 Comments

deval oza Over a year ago

In my both query there is an array of userid.SO for that this query will work? or i have to put for-loop for that?

Barmar Over a year ago

If you have an array of results, I array_intersect() should have worked. You should post your code and we may be able to help you with why it doesn't.

deval oza Over a year ago

"Catchable fatal error: Object of class stdClass could not be converted to string" this error will show when i try to load the page

Collectives™ on Stack Overflow

merge two query into one single query in sql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related