I just hit a huge road block and I am not sure what to do.

This query works on all database except firebird:

select mstwid as warehouseCode, mstiid as itemCode order by warehouseCode

The error that it gives is Column unknown WAREHOUSECODE

I am using a persistence layer that uses this construct....
Other then, "use a different persistence layer", does anyone have any
advice?

Thanks
Mark