Monday, April 6, 2015

Intersect or Minus mysql query

Follow the below query for two table minus query:



SELECT field1,field2 FROM tableA

WHERE field1 NOT IN ( SELECT field1 FROM tableB)
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Suomen kieli (Imperfekti)

In Finnish, the imperfekti is the past tense that describes actions that happened in the past, like the English simple past (e.g., "I ...