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

[amphiplex]

Why not simply do

select c,a,b from table where something;

?
---- amphiplex

[Abigail-II]

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