Hassle-free live chat software re-imagined for business growth. 2 users, always free.
SELECT DISTINCT j.name, max(r.attempt) AS highest, j.active, j.jobID, r.lev FROM (journals j LEFT JOIN responses r ON r.jobID=j.jobID) WHERE j.contactID = 220 GROUP BY r.jobID
|Whether to use true/false, yes/no or 0/1||11||51|
|Determining creation & modification dates on MySQL tables||4||15|
|Is it possible to replace huge Multiple Spaces with a single space in SQL Server||2||18|
|Single quotes on sqlsrv (mssql+php) prepared statements with parameters save as two quotes into DB||4||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!