Querying A View Problem

[gkrenton]

I've created a view that is behaving oddly when I try to query it for other uses in dbaccess yet it behaves correctly if I'm using Access, Crystal or some other ODBC connection.

The view name is ren_products & if I do a
select * from ren_products
where sku=55154

Dbaccess returns all records, yet if I create the same sql code in crystal or access I get the one record I'm looking for.

I'd assume I did something wrong in my 'create' view statement since I'm pretty much self taught. The create statement is as follows:

create view ren_products (name, teaser, stddescription, unitprice, unitretail, sku, active, vendor, fulldescription, weight, taxable, shippable, warehouseid, Instock, Reorder, pointsearned, pointscost, invmode, customfield0, customfield1, customfield2, customfield3, customfield4, customfield5, thumbnail, stdimage, stdimageparams, lastupdated, manufacturer, storeid, vendorid, largeimage, largeimageparams, merchantsku, clearance, brandtype, manufacturerpartnumber, newproduct, newproductexpiration, topseller, engraving, engravingcost, updateflag ) as ......

Any suggestions/help as to what I could have to done to have a view not behave properly? I can certainly post the remainder of the query that generates the view but not sure that's where the problem resides.

Any insight is appreciated.

Thanks
-Gina