Search results

  1. K

    Order by column alias problem

    Hi, I changed from MS SQL-Server to MS Access in an application and a SQL-select statement stoped to work. Here is the code: "SELECT TblContact.*,(select top 1 cs.sendTime FROM TblContactSent cs WHERE TblContact.contactId = cs.contactId ORDER BY cs.sendTime DESC) as ST from tblContact ORDER BY...
Back
Top Bottom