subject:"SQL question about JOIN"

RE: SQL question about JOIN

2001-09-19 Thread DeVoil, Nick

ws in the ACTIVITYLOG, the 2 queries will return different data. If that's an impossible situation, then the second query is fine. Nick -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 6:45 PM To: CF-Talk Subject: SQL question about JOIN

RE: SQL question about JOIN

2001-09-19 Thread Alistair Davidson

TECTED]] Sent: 18 September 2001 18:45 To: CF-Talk Subject: SQL question about JOIN The first query takes 9seconds to process, the 2second query takes 1seconds to process. They return the same data. Why should you use an LEFT OUTER JOIN, or any JOIN for that matter when you can say WHERE

SQL question about JOIN

2001-09-18 Thread Chad Gray

The first query takes 9seconds to process, the 2second query takes 1seconds to process. They return the same data. Why should you use an LEFT OUTER JOIN, or any JOIN for that matter when you can say WHERE JOBINFO.JOBNUM = ACTIVITYLOG.JOBNUM??? SELECT JOBINFO.JOBNUM, JOBINFO.JOBNAME, JOBINF