That's real syntax for inline assignment of a column value to a user
variable. What MySQL version are you using?
PB
Jeff McKeon wrote:
> Peter,
>
> I'm unfamiliar with the "@d := " section you describe. Is this psudo
> code or real syntax?
>
> thanks,
>
> Jeff
>
>
>
> -----Original Message-----
> *From:* Peter Brawley [mailto:peter.brawley@stripped]
> *Sent:* Monday, April 25, 2005 4:17 PM
> *To:* Jeff McKeon
> *Cc:* mysql@stripped
> *Subject:* Re: Query question
>
> Jeff,
>
> Then do it with 2 queries,
>
>SELECT @d := MAX( datestamp )
>FROM table2
>WHERE parentID = X;
>
> SELECT *
> FROM table2
> WHERE parentID = X AND datestamp=@d;
>
> PB
>
> -----
>
> Jeff McKeon wrote:
>
>>Thanks all but I don't have a mysql version high enough for subqueries.
>>
>>Thanks,
>>
>>Jeff
>>
>>
>>
>>>-----Original Message-----
>>>From: Peter Brawley [mailto:peter.brawley@stripped]
>>>Sent: Monday, April 25, 2005 4:01 PM
>>>To: Jeff McKeon
>>>Cc: mysql@stripped
>>>Subject: Re: Query question
>>>
>>>
>>>Jeff,
>>>
>>>Something like ...
>>>
>>>SELECT *
>>>FROM table2 AS a
>>>WHERE datestamp = (
>>> SELECT MAX( b.datestamp )
>>> FROM table2 AS b
>>> WHERE a.parentID = b.parentID
>>>);
>>>
>>>PB
>>>
>>>-----
>>>
>>>
>>>Jeff McKeon wrote:
>>>
>>>
>>>
>>>>I have a table that contains records that link back to a
>>>>
>>>>
>>>main talbe in
>>>
>>>
>>>>a many to one configuration linked by table1.id = table2.parentid
>>>>
>>>>Table1 (one)
>>>>Table2 (many)
>>>>
>>>>I want to pull the latest records from table2 for each
>>>>
>>>>
>>>record in table1
>>>
>>>
>>>>where certain criteria applie.
>>>>
>>>>So, if record 100 in table1 links to 5 corresponding records
>>>>
>>>>
>>>in table2,
>>>
>>>
>>>>I want to pull the latest record from table2 where table2.parentid =
>>>>100 and table2.user not like 'john'
>>>>
>>>>There is a datestamp field in table2.
>>>>
>>>>I just can't figure out how to do this.
>>>>
>>>>Thanks,
>>>>
>>>>Jeff
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>--
>>>No virus found in this outgoing message.
>>>Checked by AVG Anti-Virus.
>>>Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005
