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)

No comments:

Post a Comment

Wordpress debug log function

Wordpress error log code: if ( ! function_exists ( 'write_log' ) ) { function write_log ( $data ) { if ( defined ( '...