trimming the value won't help. Numeric IDs are faster however. The DB pads
chars with spaces when comparing anyway.
Try this:
> SELECT *
> FROM temptblJOBEVL t
LEFT OUTER JOIN
tblEmployee tt ON
t.sys_emp_id_nr = tt.emp_id_nr
> WHERE tt.emp_ID_nr IS NULL
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 11:09 AM
To: CF-Talk
Subject: Re: SQL HELP
Ltrim(rtrim()) might help, though...
On 10/15/02 6:03 AM, "Joshua Tipton" <[EMAIL PROTECTED]> wrote:
> The column is char 10 when I change it to int it truncates my numbers so I
> do not want that.
>
> Josh
>
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 8:59 AM
> To: CF-Talk
> Subject: RE: SQL HELP
>
>
> yes it may - unless you put ltrim(rtrim()) around the field values -
change
> to an int and see what hapens
>
> -----Original Message-----
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> Sent: 15 October 2002 13:52
> To: CF-Talk
> Subject: RE: SQL HELP
>
>
> Both char(10) I can change them to int is you think it would make a
> difference.
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 8:44 AM
> To: CF-Talk
> Subject: RE: SQL HELP
>
>
> shouldn't make a difference.
>
> What field type is emp_id in table tblemployee? Is it the same as
> SYS_EMP_ID_NR in temptblJOBEVL? Are they integers?
>
> Your syntax looks fine to me.
>
> -----Original Message-----
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: 15 October 2002 13:38
> To: CF-Talk
> Subject: RE: SQL HELP
>
>
> first of all I don't think you need the first ()
>
> try this.
>
> SELECT *
> FROM temptblJOBEVL
> WHERE SYS_EMP_ID_NR NOT IN
> (SELECT emp_id_nr
> FROM tblemployee)
>
> tony
>
> Tony Weeg
> Senior Web Developer
> Information System Design
> Navtrak, Inc.
> Fleet Management Solutions
> www.navtrak.net
> 410.548.2337
>
>
> -----Original Message-----
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 8:40 AM
> To: CF-Talk
> Subject: SQL HELP
>
>
> For some unknown reason this query does not work correctly even though I
> know that there is data in temptbljobevl that does not match tblemployee
> data. Can someone please help me do this via a join.
>
>
> Thanks,
>
> Joshua Tipton
>
> SELECT *
> FROM temptblJOBEVL
> WHERE (SYS_EMP_ID_NR NOT IN
> (SELECT emp_id_nr
> FROM tblemployee))
>
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
