Hi,
I have a table structure like below.
Flyer_data_field_values
ID
FLYER_ID
Field_id
Value
Sample data is
2872011 | 368131 | 309 | Accord
2872012 | 368131 | 311 | Honda
2872013 | 368131 | 313 | Black
2872014 | 368131 | 308 | 102849
2872015 | 368131 | 307 | 4491.0 usd
2872016 | 368131 | 310 | 1997
2872017 | 368131 | 314 | Vast.com
2872018 | 368131 | 315 | North Canton, OH, 44720, United States
2872019 | 368131 | 316 |
http://www.vast.com/detail/cars/ob-
2872020 | 368132 | 309 | Accord
2872021 | 368132 | 311 | Honda
2872022 | 368132 | 313 | BLACK
2872023 | 368132 | 312 | 4dr Sdn EX Auto V6 Sedan
2872024 | 368132 | 308 | 124805
2872025 | 368132 | 307 | 4988.0 usd
2872026 | 368132 | 310 | 1997
2872027 | 368132 | 314 | eBizAutos.com
2872028 | 368132 | 315 | Highland, IN, 46322, USA
2872029 | 368132 | 316 |
http://thomas-dodge-online.ebizautos.com
2872002 | 368130 | 309 | Celica
2872003 | 368130 | 311 | Toyota
2872004 | 368130 | 313 | Red
2872005 | 368130 | 308 | 114907
2872006 | 368130 | 307 | 5991.0 usd
2872007 | 368130 | 310 | 1993
2872008 | 368130 | 314 | Vast.com
2872009 | 368130 | 315 | Libertyville, IL, 60048, United States
2872010 | 368130 | 316 |
http://www.vast.com/detail/cars/ob-
Here I want to have one optimized query which will find content of value field of 308 and 307(field_id) where 311=Toyota 309 = Celica and 310 = 1993
I want result as this
2872005 | 368130 | 308 | 114907
2872006 | 368130 | 307 | 5991.0 usd
with the following criteria
311=Toyota 309 = Celica and 310 = 1993
Can some one help me.