I have the following query below (at the bottom of post) that works fine, it returns the overall results I want. BUT in ultradev I add the following line at the end of the query, "WHERE tblGeneralTicketInfo.userID='MM_ColParam"
(and MM_ColParam has a value of RequestQueryString("userID"
This is because I have set it up when a user logs in, his userID is carried on through the URL parameter so that only his ticket is visible. This method works fine with simpler querys where I select all fields from a single table. Howeverr when I try a more complex query like the one below where I try to join tables I get an error in ultradev stating that I have an error in my syntax.
SELECT tblGeneralTicketInfo.Ticket_Number, Count(tblcommentslog.Ticket_Number) AS CountOfTicket_Number
FROM tblcommentslog INNER JOIN tblGeneralTicketInfo ON tblcommentslog.Ticket_Number = tblGeneralTicketInfo.Ticket_Number GROUP BY tblGeneralTicketInfo.Ticket_Number
(and MM_ColParam has a value of RequestQueryString("userID"
This is because I have set it up when a user logs in, his userID is carried on through the URL parameter so that only his ticket is visible. This method works fine with simpler querys where I select all fields from a single table. Howeverr when I try a more complex query like the one below where I try to join tables I get an error in ultradev stating that I have an error in my syntax.
SELECT tblGeneralTicketInfo.Ticket_Number, Count(tblcommentslog.Ticket_Number) AS CountOfTicket_Number
FROM tblcommentslog INNER JOIN tblGeneralTicketInfo ON tblcommentslog.Ticket_Number = tblGeneralTicketInfo.Ticket_Number GROUP BY tblGeneralTicketInfo.Ticket_Number
