Re: CASE .. WHEN .. returns NULL

2005-06-09 Thread Alvaro Cobo
I am still trying, and I have run the EXPLAIN function over the query and I have received the following result: id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY tbl_f4Granjas index FK_ProjectHolderId 255 5 (null) 2 DEPENDENT SUBQUERY NULL NUL

Re: CASE .. WHEN .. returns NULL

2005-06-09 Thread Simon Garner
Alvaro Cobo wrote: Hi guys: I am here again asking for your generous and wise advise: I have a table (tbl_f4Granjas) with the information of some farms, their whole land extension (field: GraExtUPA) and the portion of the land they are managing in an agro-ecological way (field: GraExtPredio).