Re: need help with select statement

2003-07-08 Thread Paul DuBois
At 4:20 -0500 7/7/03, Anthony Scism wrote: I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL

need help with select statement

2003-07-07 Thread Anthony Scism
I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL | | | observing_site |

Re: need help with select statement

2003-07-07 Thread Nils Valentin
Hi Antony, Eventually key is a reserved word ?? ;-) nice one !! Best regards Nils Valentin Tokyo/Japan 2003 7 7 18:20Anthony Scism : I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time

Re: need help with select statement

2003-07-07 Thread Nils Valentin
: Thank you very much, I should have thought of that. -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 4:34 AM To: Anthony Scism; [EMAIL PROTECTED] Subject: Re: need help with select statement Hi Antony, Eventually key is a reserved word

Need help with select statement.

2001-02-26 Thread David Jacobowitz
Dear Sir, I have looked in the manual but could not find any clue so I am seeking your assistance. I have a table with 25 fields and I use most of these fields but not all in different DBI scripts. Currently I use: SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;

Re: Need help with select statement.

2001-02-26 Thread David Jacobowitz
Thanks Rolf From: "Rolf Hopkins" [EMAIL PROTECTED] To: "David Jacobowitz" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Need help with select statement. Date: Tue, 27 Feb 2001 09:21:57 +0800 No it's not possible but you can just read in all tables anyway and ignore t