MySQL Forums
Forum List  »  Spanish

Re: SQL Query
Posted by: Jesús Uzcanga
Date: October 22, 2017 05:19PM

Hi Alvaro, por tu nombre supongo que hablas español y este foro es únicamente para español y por eso te respondo en español.

Tu problema se resuelve de una forma muy sencilla pero das muy poca infoamción sobre las tablas implicadas.

Igual debería ser algo muy parecido a esto:

SELECT TABLA1.STORE_NAME, COUNT(*) AS NUM_ORDERS FROM TABLA1 INNER JOIN TABLA2 ON TABLA2.IDORDER=TABLA1.IDORDER
WHERE TABLA2.FECHA=CURDATE()-1
GROUP BY TABLA1.IDSTORE

___________________________
Ing. Jesús Alfredo Uzcanga
Twitter: @JesusUzcanga

We learn the 20% of what we HEAR,
the 50% of what we SEE,
the 80% of what we DO and
the 95% of what we TEACH.

____________________________________________________________
https://www.linkedin.com/in/jauzcanga/

Options: ReplyQuote


Subject
Views
Written By
Posted
953
October 22, 2017 01:51PM
Re: SQL Query
371
October 22, 2017 05:19PM
458
October 23, 2017 07:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.