Whats wrong with my join statement?

[COHENMARVIN]

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 = 'm*****@micro-net.com' Order By
TableFlights.OrganizerLastName, TableFlights.OrganizerFirstName

-- Marvin

[Hugo Kornelis]

On 2 Nov 2005 14:01:52 -0800, COHENMARVIN wrote:

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 = 'm*****@micro-net.com' Order By
TableFlights.OrganizerLastName, TableFlights.OrganizerFirstName

-- Marvin

Hi Marvin,

You're missing one closing parenthesis.

==> char(10,TableFlights.

should be

==> char(10),TableFlights,

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)