gt; alternatives.
>
> On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote:
>
>>I'm trying to do a fairly simple select of a
>>column from a table where the date of that column
>>happens to be the highest value. I tried this:
>>
>>SELECT name FROM produc
I'm trying to do a fairly simple select of a
column from a table where the date of that column
happens to be the highest value. I tried this:
SELECT name FROM products WHERE prod_type='foo' AND
added=(SELECT MAX(added) FROM products WHERE
prod_type='foo');
But I get the error:
ERROR 1064: You h
get information back for
this item:
990227 03-08-02 WAITING
Is there a good way to do this in one or
two queries?
Any tips would be most appreciated. Thanks
in advance!
Jeff Shipman E-Mail: [EMAIL PROTECTED]
Systems Programmer Phone: (505) 835-5748
NMIMT Computer Center http
where tab1.col1 not in tab2;
Please tell me how I can do this type of
query.
Jeff Shipman E-Mail: [EMAIL PROTECTED]
Systems Programmer Phone: (505) 835-5748
NMIMT Computer Center http://www.nmt.edu/~jeff
-
B
I have two databases that have identical table
structures. I would like to copy all data from
the 'tickets' and 'notes' in one db to the
'tickets' and 'notes' field in the other. How
could I do this?
Thanks,
Jeff Shipman E-Mail: [EMAIL PROTE
27;ve also compiled it on Linux
with no problems. I followed the recommended
configure line in the README.
Thanks in advance
Jeff Shipman E-Mail: [EMAIL PROTECTED]
Systems Programmer Phone: (505) 835-5748
NMIMT Computer Center http://www.nmt
This does not work for me. It returns syntax
errors.
Jeff Shipman E-Mail: [EMAIL PROTECTED]
Systems Programmer Phone: (505) 835-5748
NMIMT Computer Center http://www.nmt.edu/~jeff
On Fri, 20 Apr 2001, Braxton Robbason wrote:
} you want a function that prepends the letter a to
r in your SQL syntax
near '= 'other', category' at line 1
Jeff Shipman E-Mail: [EMAIL PROTECTED]
Systems Programmer Phone: (505) 835-5748
NMIMT Computer Center http://www.nmt.edu/~jeff
-
Before p
easy with an
'ORDER BY 1 2', but I would like categories that
are named 'other' to be put off until the end. So,
I'd get something like this:
abcd
ghikj
z
other
Is there a way to do this type of query? Thanks in
advance.
Jeff Shipman E-Mail: [EMAIL PROTECTED