You gave table Tickets an alias of T, so you must use T as the table name. Either use T, or drop the alias (which you seem not to be using anyway).
--- Ben -----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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
