Annoying SQL problem - CI forums are the best :)

[eluser]Teks[/eluser]
If you give a slightly more detailed description of what your tables are like, we might be able to provide a more specific solution. From your description, however, it does sound like you may be making things more complicated than they need to be - that is, you may not need a join statement at all. Select statements can include more than one table, if needed, without needing to use joins:

Code:

SELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column1 = table2.column1;

It sounds like a simple select stament, such as the one above, with a LIMIT might be enough to do what you require.