Tough SQL question: How to avoid redundancy in a subquery!

Thread View: borland.public.vdbase.data.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by sh2222 Wed, 21 Apr 1999 00:00

#75

Author: sh2222
Date: Wed, 21 Apr 1999 00:00

11 lines
1051 bytes

Suppose I have a subquery within a query.  The query gets its data
directly from a table.  It uses some criteria to pick certain records.
The subquery (a select statement) within the query uses the same
criteria.  Is there any way to reference the query, in the 'From'
clause of the subquery for instance, in order to avoid repeating the
same criteria for the subquery?  I'm not even sure if this makes any
sense since the subquery is part of the query! Confused? I am!

Thanks, 

A.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads