Doesn't this
FROM Tickets T,
Mean that in your SQL it should be reffered to as T ?
-----Original Message-----
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2001 15:37
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
