MYSQL / Query Builder Class help

Judging from the kind of help you're requesting now.
I suggest that you stop where you are right now,
and start learning basics of SELECT'ing queries.
because you're asking a questions about your query,
without even bothering to read the documentation.
or at least do some experiments for your sql query with CI's Query Builder,
and then ask here if you're really, really stuck