------=_NextPart_000_0009_01C35A6F.9908B420
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
Hallo
suppose you have a table with great number of columns (20 or 30),
and you would like to specify every one but two or tree columns in a =
SELECT statement.
Is there a way to specify only those two or tree columns for omission =
(which would be the 'short' way to do the job) instead of specifying =
every column that needed (which would be the 'long' way to do the job).
Example:
The 'TName' table header:
id | name | surname | dateOB | idSCHOOL | idCITY | idSTATE | sex | =
idParent1 | idParent2 | interests | weight | height | age | auditDate | =
idAudittor | ....
You need every field except the 'dateOB' and 'idSCHOOL'
Ordinary select wold be:
SELECT =
id,name,surname,idCITY,idSTATE,sex,idParent1,idPar ent2,interests,weight,h=
eight,age,auditDate,idAudittor, ....
FROM TName
It is too long expression,=20
is there a way to specify only 'dateOB' and 'idSCHOOL' - the two column =
that are unwanted in the result set - in order to make the SELECT =
shorter? The SELECT should return every column but the specified ones.
------=_NextPart_000_0009_01C35A6F.9908B420--