Andrew It should return NULL.
Explain a little more please on point 2, what your trying to do -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Dickinson Sent: Thursday, June 26, 2003 5:00 PM To: CFAussie Mailing List Subject: [cfaussie] Somewhat OT : SQL Left Join I'm taking my first cautious steps into coding with Left/Right Joins. If a record is in one table but not another, what value is expressed ? Is it Null ? I'm looking for a way to capture "in onr table but not another" as a value to increment an array-variable. The approach I'm currently using has one "driver" query with three queries nested inside it, and it is of course horrendously slow (about 180 seconds). --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
