[sqlite] Select Limit issues

[Webmaster]

I have never posed in a group before forgive me if I am out of line with my
question.

I have a table called table1
With three fields: Field1, Field2, Field3

Here is my query but I get errors.
Any help work be great

select field1, field2 from
( select * from ee_table1
   where field2 = 'blue' limit 1
   and field1 < (select min(field1) from (select  * from ee_table1
                                       where field2 = 'white' limit 4
                                       and field1 < (select field1 from
ee_table1 where field2 = 'red' limit 1 ) order by field1 desc) a )
   order by field1 desc
) previous_blue

union all

select field1,field2 from
( select * from ee_table1
   where field2 = 'white' limit 4
      and field1 < (select field1 from ee_table1 where field2 = 'red' limit
1)
   order by field1 desc
) previous_5_white

union all

(select field1, field2 from ee_table1 where field2 = 'red' limit 1)

union all

select field1,field2 from
(  select * from ee_table1
   where field2 = 'white' limit 4
      and field1 > (select field1 from ee_table1 where field2 = 'red' limit
1)
   order by field1 asc
) next_5_white

union all

select field1,field2 from
(  select * from ee_table1
   where field2 = 'blue' limit 1
   and field1 > (select max(field1) from (select * from ee_table1
                                       where field2 = 'white' limit 4
                                       and field1 > (select field1 from
ee_table1 where field2 = 'red' limit 1) order by field1 asc) a )
   order by field1 asc
) previous_blue




Thanks in advance
Sticky

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users