401 reputation
1313
bio website
location
age
visits member for 2 years, 9 months
seen yesterday

1d
asked Delete fabricante_producto_solicitud only if is not related to modelo_marca_producto
Jan
22
comment NOT IN statement or what to use in this case?
@CraigRinger can you share your suggestion? Is more efficient than the one by Miguel?
Jan
22
comment NOT IN statement or what to use in this case?
What you mean with consider NULL? Can you improve the answer?
Jan
22
awarded  Yearling
Jan
22
comment NOT IN statement or what to use in this case?
can you take a look to the edit I made based on your answer?
Jan
22
accepted NOT IN statement or what to use in this case?
Jan
22
revised NOT IN statement or what to use in this case?
added 616 characters in body
Jan
22
revised NOT IN statement or what to use in this case?
deleted 698 characters in body; edited title
Jan
22
asked NOT IN statement or what to use in this case?
Jan
9
awarded  Popular Question
Jan
4
comment Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
I'm still getting problem with query not returning the right result, can you take a look to my latest edit?
Jan
4
revised Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
added 1212 characters in body
Dec
31
accepted Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
Dec
30
comment Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
Sample data is already on the main post and expected result should be any pais.id, pais.nombre where pais.id is different from 6, 1, 2, 3, 5, 8 because this are the ones on pais_fabricante_producto_solicitud table. If you run my first query you'll get this ouput
Dec
30
comment Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
yep, I've fixed that part but your query return no records meaning empty results
Dec
30
revised Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
added 117 characters in body
Dec
30
comment Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
I've tried your query and get empty results
Dec
30
revised Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
added 738 characters in body
Dec
30
revised Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
added 738 characters in body
Dec
30
comment Get the pais_id not associated to fabricante_distribuidor_id and producto_solicitud_id, the opposite from SELECT query
I messed up with my question (was 4AM while I was writing) so I add some extra information, can you take a look and reformulate your answer? Also if you need I can provide you with some kind of data for testing purposes