Try this,
SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON (T.TicketStatus = Types.TypeID) WHERE T.UserID = Users.UserID I am assuming TicketStauts and TypeID are the same datatype. Mike -----Original Message----- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
