It is giving me a unrecognized phrase/keyword error:

create sql view trouble_ticket as;
select top 1 Trouble_ticket.trouble_ticket_id,;
Trouble_ticket.tt_problem, Trouble_ticket.tt_solution,;
Trouble_ticket.tt_sent_to_tech, Trouble_ticket.tt_monitor_name,;
Trouble_ticket.system_serial, Trouble_ticket.tt_location_city,;
Trouble_ticket.tt_location_address,;
Trouble_ticket.tt_datetime_of_ticket,;
Trouble_ticket.tt_datetime_of_incident,;
FROM dbo.Trouble_Ticket

I also tried: create remote view trouble_ticket as;....

and it said there was a syntax error

can 'top' be used in visual foxpro 6?
I know it can be used in sql server 7.