How can we use one query result in another query in MySQL?

How can we use one query result in another query in MySQL?

1 Answer

1. Using IN(subselect): SELECT count(people) AS totalPeople , people FROM people INNER JOIN photopeople ON photoPeople.peopleID = people.PeopleID WHERE photoid IN (select photoID from photoSearch where photoID between 1 AND 50000) GROUP BY people ORDER BY totalPeople DESC.
2. Using JOIN.

How can we use or in a query?

Use the OR criteria to query on alternate or multiple conditions

1. Open the table that you want to use as your query source and on the Create tab click Query Design.
2. In the Query Designer, select the table, and double-click the fields that you want displayed in the query results.

Can you query a query in access?

1 Answer. Using MS Access, it is possible to save both of these queries and then add them by query name to the query design window. Once added, you can create an INNER JOIN between the two queries by dragging and dropping the relevant field name from one to the other.

Can a form display data from query?

A form is a database object that you can use to enter, edit, or display data from a table or a query. You can use forms to control access to data, such as which fields of data are displayed.

Where is the result of the query displayed in Access?

When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view: On the Home tab of the Ribbon, click the View command.

How to use results from one query in SQL?

SELECT COUNT (people) AS totalPeople, people FROM people INNER JOIN photopeople ON photoPeople.peopleID = people.PeopleID WHERE photoid IN (‘ID’s from results’) GROUP BY people ORDER BY totalPeople DESC But I understand from others and resources, that the IN clause will not perform well, especially as I could have 100,000 plus photoID’s.

How to get column from sub query in MySQL?

Joins / the left join allows you to combine rows of tables within one query on a given condition. The condition could be id = 5 for your purpose. use below query to get column from sub query. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Provide details and share your research!

How to combine rows in one query in MySQL?

Have a look here: http://www.mysqltutorial.org/mysql-left-join.aspx Joins / the left join allows you to combine rows of tables within one query on a given condition. The condition could be id = 5 for your purpose. use below query to get column from sub query.

Do you have to run a query to get the adblockid?

First I have to run the query (1) using the pagedetailid number to get the adblockid. Then I have to put that adblockid into the other query (2) to get the result. What I would prefer is a single query.