HOw 2 select Multiple fields

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’
**