Posted by COHENMARVIN on 11/03/05 00:01

The following sql statement is rejected by asp.net (working with sql
server). It says something is wrong near "TableFlights". But I don't
see anything wrong with it.
Any help is appreciated:

SELECT TableFlights.IdFlight, Concat = (TableFlights.OrganizerLastName
+ ', ' + TableFlights.OrganizerFirstName + ' Flt:' +
TableFlights.FlightNumber + ' on ' +
Convert(char(10,TableFlights.FlightDate,101)) FROM TableFlights INNER
JOIN TablePassengers ON TableFlights.IdFlight=TablePassengers.IdFlight
Where TablePassengers.Email = 'marvin@micro-net.com' Order By
TableFlights.OrganizerLastName, TableFlights.OrganizerFirstName

-- Marvin

[Back to original message]