Re: Query CDS

Article View: borland.public.interbase.sql

Article #793

Back to borland.public.interbase.sql Previous Next

#793

From: Bill Todd
Date: Wed, 18 Jul 2007 22:34

18 lines
1561 bytes

Serra wrote:

> CDS (OrderDetail Table) :
> 
> PartNo  PartName  Qty   UPrice
> --------------------------------------------
> AAA        AAAAA      1       100
> BBB        BBBBB     10      200
> CCC       CCCCC    20      300
> 
> above 3 records are not in Database ( not applyupdates yet )
> now i want to open Parts table with just above 3 partno (AAA,BBB,CCC)

SELECT * FROM PARTS WHERE PARTNO = 'AAA' OR PARTNO = 'BBB' OR PARTNO =
'CCC'

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <469e9583@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<469bdbf9$1@newsgroups.borland.com> <469bf567$1@newsgroups.borland.com> <469e7611@newsgroups.borland.com> <469e893d$1@newsgroups.borland.com> <469e9074@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,76c2c8ad3cbcc7f0
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Query CDS
Newsgroups: borland.public.interbase.sql
References: <469bdbf9$1@newsgroups.borland.com> <469bf567$1@newsgroups.borland.com> <469e7611@newsgroups.borland.com> <469e893d$1@newsgroups.borland.com> <469e9074@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <469e9583@newsgroups.borland.com>
Date: 18 Jul 2007 15:34:43 -0700
X-Trace: newsgroups.borland.com 1184798083 216.207.211.19 (18 Jul 2007 15:34:43 -0700)
Lines: 18
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message