406 reputation
1315
bio website
location
age
visits member for 2 years, 11 months
seen Mar 14 at 17:21

Mar
13
revised Get list of excluded databases from command line by asking user
added 1 character in body
Mar
13
asked Get list of excluded databases from command line by asking user
Feb
10
awarded  Critic
Feb
3
awarded  Tumbleweed
Jan
27
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