Re: easy question
Posted in 2004
Topics: SQL Development & Query Writing
Well, There are no easy questions... And in you query you could use the EXISTS clause of the SELECT statement. SQL states for Structured Query Language. Chucho! -----Original Message----- From: "Rein Puksand" <rpuksand@epbe.ee> To: <informix-list@iiug.org> Date: Mon, 27 Sep 2004 18:02:22 +0300 Subject: easy question Hello, Easy question! Two tables table1 (number, lname) and table2(number,lname). I want to find elements (lname) from table1, only that not exist in table2 but values in number fields are equal? table1.number = table2.number and table1.lname not in table2.lname Example: Table1 1 Marc 2 Edy 1 hex 4 Mary 2 Sed Table2 1 hex 1 Sed 4 Mary 1 Marc 2 troy and result must be: 2 Edy, 2 Sed What is sql? very thanks, Rein Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list