query get invalid operation
Posted on 2007-03-23
I'm getting an invalid operation on the query below, so, I must be missing something. I just want to list only items (another field) where the webid is in the first table. WebID and OpptyDescription are both text fields with 255 characters. qryActiveTickets get data from tblTickets, but, does some filtering. If I replace qryActiveTickets with tblTickets in the query below, no problem.
SELECT tblGMPSAccts.WebID, qryActiveTickets.TicketNumber
FROM tblGMPSAccts LEFT JOIN qryActiveTickets ON tblGMPSAccts.WebID = qryActiveTickets.OpptyDescription;