in reply to Help my syntax

As a stylistic issue, in SQL it's probably best to specify the columns you want returned (SELECT THIS, THAT, THE_OTHER...) vs using SELECT *; the table you're reading may have columns added or rearranged.

Replies are listed 'Best First'.
Re^2: Help my syntax
by Cop (Initiate) on Dec 22, 2007 at 03:34 UTC

    Bless you. How many times in the past I was worried about the select * problem. It introduces the potential of breaking receiving structures. Anyone answered the question without pointing out that is a nut.