Copy link to clipboard
Copied
SELECT #tonsn#.OtherNumSysName, #tonsnn#.OtherNumSysNum, #tonsnn#.ID
FROM #tonsnn# LEFT JOIN #tonsn# ON #tonsnn#.OtherNumSysName = #tonsn#.ID
WHERE #tonsnn#.mainID=<cfqueryparam value="#URL.which#" cfsqltype="cf_sql_integer">
ORDER BY #tonsn#.OtherNumSysName;
What's up with this?
Have something to add?