AFAIK NULL is returned - this is true of Oracle and MSSQL - I don't know if it's DBMS specific though...
- J -----Original Message----- From: Andrew Dickinson [mailto:[EMAIL PROTECTED] Sent: Thursday, 26 June 2003 17:00 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/
