[AccessD] Alias Table Name

It's just standard aliasing using the keyword "AS"  to keep the SQL statement managable.


On 14 Apr 2008 at 21:16, Rocky Smolin at Beach Access  wrote:

> SELECT P.MatterActionID, P.PersonID, P.HoursRemaining, A.TotalHoursRemaining

Here's your P
> FROM qryHoursRemainingByMatterActionAndPerson AS P 

> INNER JOIN

and here's your A
> qsumHoursRemainingByMatterAction AS A

> ON P.MatterActionID = A.MatterActionID
> WHERE (((P.PersonID)=getpid()) AND ((P.HoursRemaining)>0) AND
> (([Forms]![frmTM]![chkHoursRemaining])<>False)) OR (((P.PersonID)=getpid())
> AND ((A.TotalHoursRemaining)<=0) AND
> (([Forms]![frmTM]![chkHoursRemaining])<>False)) OR (((P.PersonID)=getpid())
> AND (([Forms]![frmTM]![chkHoursRemaining])=False));
> 
> Two field lists aliased as A and P.
> 
> Rocky
>  
> 
> 
> 
> 
>  	
> 	
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Monday, April 14, 2008 5:01 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Alias Table Name
> 
> Rocky, can you show us the SQL? 
> 
> Susan H. 
> 
> 
> > Not in this case.  No source.
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> No virus found in this incoming message.
> Checked by AVG. 
> Version: 7.5.519 / Virus Database: 269.22.13/1376 - Release Date: 4/13/2008
> 1:45 PM
>  
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com