SQLite selecting all from multiple tables and reading from cursor

I have a query which retrieves data from different tables

select * from customer c, order o where c.id = o.pID 

both tables have a column 'date_created' and i want to retrieve the date_created from order table

I tried Cursor c = db.execute(sql); String dateCreated = c.getString("date_created") which returned the customer date and not the order date. when i try c.getString("o.date_created") my app crashes and returns "E/SQLiteCursor: requesting column name with table name -- o.date_created
java.lang.Exception"

can someone please guide me on how i can get the order date_created?
I

How about this:

select *, c.date_created as customer_date_created, o.date_created as order_date_created from customer c, order o where c.id = o.pID

then just use:

c.getString("order_date_created");

You can differentiate the column name by using Alias name as below:

select c.date_created as cust_date, o.date_created as order_date from customer c, order o where c.id = o.pID 

Then try:

c.getString("order_date");

The resultset of your query contains 2 columns with the same name, so when you try to retrieve the column by the name date_created you can't be sure which one you get.<br/>
This is why you must use aliases for all columns that have the same name:

select c.column1, c.column2, c.date_created as cust_date_created, .....
       o.column1, o.column2, o.date_created as ord_date_created, ....
from customer c inner join [order] o 
on c.id = o.pID  

You can omit the columns that you don't want in the results.<br/>
Also use proper join syntax.<br/>

Now you can get the column's value by:

String dateCreated = c.getString(c.getColumnIndex("ord_date_created"))