Displaying results of a SQL join in a ListActivity?

Try selecting one of your columns as ID alias.

Try selecting one of your columns as _ID alias select col1 as _id from table.

Perfect solution - many thanks. – Andrew Ebling Aug 14 '10 at 17:28.

To use CursorAdapter (or any of its subclasses) you're required to have the "_id" column; it's explicitly stated in the documentation. That's because CursorAdapter uses this column heavily. What I recommend is whatever you think (based on your project) to be the easier of these two paths: Create an _id field in one of the tables so that when you join, you end up with an _id field.

Implement your own ListAdapter (starting from BaseAdapter) that is essentially a CursorAdapter but doesn't require an _id field. I suspect #1 would be easier to do if you control the database, but that you'd have to do #2 if you cannot change the databases' schema.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.