I'm trying to query a table (lets call it "InvoicesTable") and I would like to include the invoices last update remark by the employee whose managing the invoice. In sql, I would probably do a subquery, using the TOP function, but informix doesn't seem to allow you to use the
We have a vendor product and in their informix database, they have their date, time and seconds separated in 3 different columns. item_date (date field) item_time (smallint field)