I am a newbie in mysql and I have a quick question about using the different join. Say for instance, I have 2 tables, one titled totals and another is titled goods and each contains values,
goods
ID | Name
--------
1 | coffee
2 | tea
3 | chocolate
totals
Quantity | goods ID
---------------------
40 | 3
20 | 2
10 | 1
Like this for example, the goods ID in total is the child of the ID of the goods table, but the display I want is
totals
Quantity | goods ID
-------------------
40 | chocolate
20 | tea
10 | coffee
I just want to know where the different joins would be applicable.
See Question&Answers more detail:os