Re: Pipe the Output of a SQL statement into the Input of another

Why not simply do

select c,a,b from table where something;
[download]

?
---- amphiplex

Comment on Re: Pipe the Output of a SQL statement into the Input of another Download Code

Replies are listed 'Best First'.
Re: Pipe the Output of a SQL statement into the Input of another by Abigail-II (Bishop) on Jul 15, 2002 at 16:33 UTC
Consider the following table: A B C D 4 5 1 7 4 5 2 8 And the where clause being `D = 7`. Then your select would return just one line, and miss the `C = 2`. If you first select the `A = 4, B = 5`, and then go for the C, you get both lines. Abigail	[reply] [d/l] [select]