Re: [GENERAL] noobie join question

2015-05-11 Thread Steve Clark
On 05/11/2015 07:16 AM, Oliver Elphick wrote: On Mon, 2015-05-11 at 06:46 -0400, Steve Clark wrote: Hi List, I am having trouble trying to figure out how to get the result listed at the bottom. I have 3 tables units, types of units which has a description of the units, and a table that list ass

Re: [GENERAL] noobie join question

2015-05-11 Thread Albe Laurenz
Steve Clark wrote: > I am having trouble trying to figure out > how to get the result listed at the bottom. That's a bit tough, since you don't describe the desired result. > I have 3 tables units, types of units which has a description of the units, > and a table that list associations of the un

Re: [GENERAL] noobie join question

2015-05-11 Thread Oliver Elphick
On Mon, 2015-05-11 at 06:46 -0400, Steve Clark wrote: > Hi List, > I am having trouble trying to figure out > how to get the result listed at the bottom. > > I have 3 tables units, types of units which has a description of the units, > and a table that list associations of the units. I can't figur

[GENERAL] noobie join question

2015-05-11 Thread Steve Clark
Hi List, I am having trouble trying to figure out how to get the result listed at the bottom. I have 3 tables units, types of units which has a description of the units, and a table that list associations of the units. I can't figure out how to do the proper joins. Any pointers would be appreciat