how to make a difference in mysql?

Question

how to make a difference in mysql?

Navigation

#1 by (2 votes)

0

I have the Table A:

-------------------
*    fechaA       *
-------------------
* 2017-09-01      *
* 2017-09-02      *
* 2017-09-03      *
* 2017-09-04      *
* 2017-09-05      *
* 2017-09-06      *
* 2017-09-07      *
* 2017-09-08      *
* 2017-09-09      *
* 2017-09-10      *
-------------------

And the Table B

-------------------
*    fechaB       *
-------------------
* 2017-09-01      *
* 2017-09-06      *
* 2017-09-10      *
-------------------

What I need is the difference of A in B

The Serious result

-------------------
*    Resultado    *
-------------------
* 2017-09-02      *
* 2017-09-03      *
* 2017-09-04      *
* 2017-09-05      *
* 2017-09-07      *
* 2017-09-08      *
* 2017-09-09      *
-------------------

The problem is that I do not know how to do it try with fechaA!=FechaB but still the result is the whole table A

mysql sql mariadb

asked by Shassain 18.09.2017 в 17:05

source

1 answer

I can not run a Java class from the Windows 10 cmd Pass the model's hash to the controller

score 2 · Accepted Answer

Have you tried with a not in?

something like:

SELECT fechaA       
FROM TABLA_A
WHERE fechaA NOT IN (SELECT FechaB FROM TABLA_B)

This what it does is to find the equal dates that are in A, with those that do not appear in B, then only bring those.