List:General Discussion« Previous MessageNext Message »
From:Jeff McKeon Date:April 25 2005 8:45pm
Subject:RE: Query question
View as plain text  
3.23.
 
no control over this right now or i'd upgrade, believe me!
 
 
jeff

	-----Original Message-----
	From: Peter Brawley [mailto:peter.brawley@stripped] 
	Sent: Monday, April 25, 2005 4:43 PM
	To: Jeff McKeon
	Cc: mysql@stripped
	Subject: Re: Query question
	
	
	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
		  


Thread
Query questionJeff McKeon25 Apr
  • Re: Query questionSGreen25 Apr
  • RE: Query questionmathias fatene25 Apr
    • RE: Query questionSGreen25 Apr
      • RE: Query questionmathias fatene25 Apr
  • Re: Query questionPeter Brawley25 Apr
    • RE: Query questionmathias fatene25 Apr
RE: Query questionJeff McKeon25 Apr
  • Re: Query questionPeter Brawley25 Apr
    • RE: Query questionmathias fatene25 Apr
      • Re: Query questionPeter Brawley25 Apr
      • RE: Query questionSGreen25 Apr
        • RE: Query questionmathias fatene26 Apr
          • Re: Query questionMartijn Tonies26 Apr
            • RE: Query questionmathias fatene26 Apr
              • Re: Query questionChris Ramsay26 Apr
                • Re: Query questionmfatene26 Apr
  • Re: Query questionPeter Brawley25 Apr
  • RE: Query questionSGreen25 Apr
RE: Query questionJeff McKeon25 Apr
  • Re: Query questionPeter Brawley25 Apr
RE: Query questionJeff McKeon25 Apr
  • Re: Query questionPeter Brawley25 Apr
RE: Query questionJeff McKeon25 Apr