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

• Next in forum: Re: Whats wrong with my join statement?
• Prev in forum: Approximate String Searches
• Thread view: Whats wrong with my join statement?

[Reply to this message]