how to use left join ?

Put problem concerning Views, Layouts and other XML-Resources (like AndroidManifest) here.

how to use left join ?

Postby chocolate » Mon Jan 18, 2010 12:45 pm

hi all,

i have an issue here,
i would like to left join two tables,
and the only way i found about left join from SDK is

setTables("A_table LEFT JOIN B_table on (A_table.Order_No = B_table.Order_No)")

and do SQLiteQueryBuilder.query

but i found out the result is not exactly what i expected.
the result what i expect is like follow ex.

Name Order_No
-------------------------------
Mr. T 7520
Mr. T 1054
Mr. s
Mr. K 2572
Mr. P 7375

and the result shows like :

Name Order_No
-------------------------------
Mr. T 7520
Mr. T 1054

Mr. K 2572
Mr. P 7375

show nothing in the name field for row 3

does anyone know how to solve this issue?
chocolate
Freshman
Freshman
 
Posts: 4
Joined: Thu Oct 15, 2009 8:57 am

Top

Return to View, Layout & Resource Problems

Who is online

Users browsing this forum: No registered users and 6 guests