Join is not behaving as expected.

[eluser]CloakandPigeon[/eluser]
[quote author="Aken" date="1361577294"]Your select() method is wrong. Items are not passed as parameters; they should either be a string or an array in the first parameter. Check the docs. [/quote]

Yeh, I think I messed that up after attempting a few different solutions I found while researching (none of which worked). I originally had it set to select all (select(*)).

From your experience does my join statement look like it would work for what I am wanting?

Thanks again for your help.