Mark,
How about explaining the need just a bit more. I'm not clear about the
max(). Are you trying to get the number and description of the last item in
the table or something else?
If you just want the description and ID of the last item in the database,
the sub-select proposed by someone earlier would be the way to go.
This way it will find the max ID then do a select on the table for the ID
(yes it's redundant but easy to reference) and text for just that ID.
--Doug
SELECT
ID_ENC_TOY_IMAGE,
ENC_TOY_IMAGE_LINK_TEXT
FROM
ENC_TOY_IMAGE (NOLOCK) ... if dirty reads are ok ...
WHERE
ID_ENC_TOY = #ID_ENC_TOY# AND
ID_ENC_TOY_IMAGE =
(
SELECT
max (ID_ENC_TOY_IMAGE)
FROM ENC_TOY_IMAGE (NOLOCK)
)
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
