The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
get values from isql query DebianJ Shell Programming and Scripting 3 06-27-2008 03:52 AM
isql in shell script help mrviking Shell Programming and Scripting 2 06-09-2006 02:11 AM
isql output d_swapneel14 Shell Programming and Scripting 4 05-23-2006 03:53 AM
regarding isql girish_shukla UNIX for Dummies Questions & Answers 2 10-21-2003 04:15 AM
isql eloquent99 UNIX for Dummies Questions & Answers 2 02-10-2003 10:05 AM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-20-2008
Registered User
 

Join Date: Mar 2008
Posts: 3
isql - select ... where ...

Hi,
Please help me to solve this problem on Unix isql. Following is an example table and expected select result. I need to select NAMEs where those NAMEs don't have a record which TYPE='T1'. I tried, but got both N2 and N3.

NAME TYPE DATA
---------------------
N1 T1 D11
N2 T1 D21
N2 T2 D22
N3 T2 D32

output of the select:
NAME
-----
N3

Thanks
Reply With Quote
Google The UNIX and Linux Forums
Forum Sponsor
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 06:31 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0