Computer Forums - View Single Post

TheHeadFL · 04-05-2006, 04:23 PM

Why wouldn't you execute a natural join if the two values match?

Code:

SELECT s.flowid, s.stepid, t.taskid FROM `stepdefinition` s, `task` t WHERE s.flowid = t.flowid AND s.stepid = t.stepid AND s.steptype = -3

04-05-2006, 04:23 PM	#3 (permalink)
TheHeadFL Ultra Techie Join Date: Jul 2005 Posts: 530	Why wouldn't you execute a natural join if the two values match? Code: SELECT s.flowid, s.stepid, t.taskid FROM `stepdefinition` s, `task` t WHERE s.flowid = t.flowid AND s.stepid = t.stepid AND s.steptype = -3 __________________ Desktop machine: 2 x Opteron 246, Asus K8N-DL, 2GB PC3200 ECC Reg., XFX GeForce 6600GT, 74gb WD Raptor, 2 x 19\" LCDs, Windows XP x64 Server machine: Intel P4 3.0GHz 2MB EM64T, ECS i865pe, 1GB PC3200, 36gb WD Raptor, Windows Server 2003 Laptop: Dell Inspiron 9100 (Intel P4 3.2GHz 1MB Prescott, i865pe, 512MB PC3200, Mobility Radeon 9700, DVD+R/DL Burner), Windows XP Linux: P3 450Mhz, 386MB ram, Slackware 10.1 (Running mySQL/Apache)