Strict Standards: Non-static method utf_normalizer::nfc() should not be called statically in /www/htdocs/w006661d/anddev/includes/utf/utf_tools.php on line 1781
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)

Strict Standards: Non-static method utf_normalizer::nfc() should not be called statically in /www/htdocs/w006661d/anddev/includes/utf/utf_tools.php on line 1781
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4362: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4364: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4365: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4366: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
anddev.org • View topic - how to use left join ?

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