ondrejko1
asked on
Sql query, is there a more efficient way to write this
Is there a more efficient way to write this query?
<CFQUERY NAME="mailregister" DATASOURCE="register">
SELECT distinct register.name, register.odate, register.ipregister, register.fname, register.lname, register.email, register.logname, register.passwd, register.acceptp, register.seqid, register.searchb1, register.searchb2, register.searchb3, register.searchb4, register.searcha1, register.searcha2, register.searcha3, register.searcha4 from register, responselog
where register.logname=responsel og.sentto and responselog.datesent = '#url.datesent#' and responselog.responsetype = 'TW' and register.acceptp = 'Yes' and responselog.readmessage = 'No'
</CFQUERY>
<CFQUERY NAME="mailregister" DATASOURCE="register">
SELECT distinct register.name, register.odate, register.ipregister, register.fname, register.lname, register.email, register.logname, register.passwd, register.acceptp, register.seqid, register.searchb1, register.searchb2, register.searchb3, register.searchb4, register.searcha1, register.searcha2, register.searcha3, register.searcha4 from register, responselog
where register.logname=responsel
</CFQUERY>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.