The UK Home Automation Archive

Archive Home

Group Home

Search Archive
Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

Latest message you have seen: Re: OT : David Miller downunder

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

OT SQL Question ?

To: ukha_d@xxxxxxx
Subject: OT SQL Question ?
From: "Dr John Tankard" <john@xxxxxxx>
Date: Wed, 02 Oct 2002 14:07:42 -0000
Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
Reply-to: ukha_d@xxxxxxx

I have left my SQL ref at home Two tables Quotes & Orders Quotes ------ QuoteID Booked(y/n) Orders ------ OrderID QuoteID I want to list all Quotes that Booked = T that dont exist in Orders ? I know I need a subquery and a IN or Exist but canntot remember how to form it John

Yahoo! Groups Sponsor

http://www.automatedhome.co.uk Post message: ukha_d@xxxxxxx Subscribe: ukha_d-subscribe@xxxxxxx Unsubscribe: ukha_d-unsubscribe@xxxxxxx List owner: ukha_d-owner@xxxxxxx List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Prev by Date: xAP - Curtain Control!
Next by Date: RE: Re: Lossless audio conversion / DIY Kivor?
Previous by thread: xAP - Curtain Control!
Next by thread: Re: OT SQL Question ?
Index(es):
- Date
- Thread

Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.