[RESOLVED] query select from 3 tables at once

[SambaNeko]

just have the uid and cid in 1 table, clever right?

Redundant and a cop-out. :/ It will not always be a simple matter to just copy a column over to another table, and relationally speaking there may be no good reason to duplicate that column either. Sooner or later, you're going to need joins.