maria-discuss team mailing list archive

[Daniel Bartholomew <dbart@xxxxxxxxxxx>]

The following question has been posted to the Knowledgebase:

https://kb.askmonty.org/en/what-join/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
I have a table called called ContenidosDeModelos with fields

+------------+-------------+------+-----+
| Field      | Type        | Null | Key |
+------------+-------------+------+-----+
| CdMID      | int(5)      | NO   | PRI |
| ModeloID   | int(5)      | NO   | MUL |
| ArticuloID | int(5)      | NO   | MUL |
| Cantidad   | float(10,3) | NO   |     |
+------------+-------------+------+-----+
which in turn is related on the field ArticuloID to a table called
CatArticulos with fields

+-----------------------+--------------------------------------
| Field                 | Type                                
+------------------------+-------------------------------------
| ArticuloID            | int(5)                              
| ArticuloCodigo        | char(7)                            
| ArticuloNombre        | varchar(45)                       
| ArticuloDesc          | varchar(75)                      
| ArticuloDeshabilitado | char(1)                         
| ArticuloUnidad        | enum('pz','mts','kg','ton','m3','lts')
+-----------------------+--------------------------------------
I want a listing of ALL of table CatArticulos (1300+ records) with the
value of the field Cantidad from the table ContenidosDeModelos for a
specified ModeloID (3 - 10 records) when there is a common ArticuloID
otherwise Cantidad should be NULL when there is no corresponding
ArticuloID in ContenidosDeModelos.

I have written at least 100 different joins that don't work. Can someone
give me a clue?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Thanks.

-- 
Daniel Bartholomew
  Google+ - http://gplus.to/dbart
  Twitter - http://twitter.com/daniel_bart

MariaDB: An Enhanced Drop-in Replacement for MySQL
        Website - http://mariadb.org
        Twitter - http://twitter.com/mariadb
        Google+ - http://google.com/+mariadb
       Facebook - http://fb.com/MariaDB.dbms
  Knowledgebase - http://kb.askmonty.org
  Monty Program - http://montyprogram.com