# HOw 2 select Multiple fields

**URL:** <https://forum.kirupa.com/t/how-2-select-multiple-fields/207893>\
**Category:** Uncategorized\
**Created:** [November 22, 2006, 2:43pm UTC](https://forum.kirupa.com/t/how-2-select-multiple-fields/207893 "2006-11-22T14:43:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![webmulgor](https://avatars.discourse-cdn.com/v4/letter/w/ed8c4c/32.png) [@webmulgor](https://forum.kirupa.com/u/webmulgor)\
**Post date:** [November 22, 2006, 2:43pm UTC](https://forum.kirupa.com/t/how-2-select-multiple-fields/207893/1 "2006-11-22T14:43:34Z")

</div>

i want to do the following thing:

[FONT=Franklin Gothic Medium]Select table.fldA, table.fldB, table.fldC, table.D from table where table.fldA = ‘aae’ and table.fldB = ‘bbx’ and table.fldC = ‘coc’ and table.fldD = ‘dss’[/FONT]  
[FONT=Franklin Gothic Medium][/FONT]  
or in other words say…  
\*\*i want to select three different fields of a table where data in field1 is (say) ‘aaa’, data in field2 is ‘sda’ and data in field3 is ‘stsse’  
\*\*