Posted by Hugo Kornelis on 11/03/05 00:14

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 = 'marvin@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)

• Next in forum: Re: Problem with HOST_NAME Function with Linked View
• Prev in forum: Whats wrong with my join statement?
• Thread view: Re: Whats wrong with my join statement?

[Reply to this message]