On 9/13/07, volunteer@xxxxxxxxxxxxxxx <volunteer@xxxxxxxxxxxxxxx> wrote:
> hello
>
> table is
> +-------+-------+------+-------+
> | id | one | two | three |
> +-------+-------+------+-------+
> | first | Jack | Jill | Mary |
> | last | Ja | Ji | Ma |
> +-------+-------+------+-------+
>
> result is
> +----+-------+-------+
> | id | one | two |
> +----+-------+-------+
> | first | Jack | Jill |
> | last | Ja | Ji |
> +----+-------+-------+
>
> query is??
Unless I am missing something crucial, this is SQL 101:
select id, one, two from foo;
Alexander.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
