[AccessD] Alias Table Name

qryHoursRemainingByMatterActionAndPerson  is P

FROM qryHoursRemainingByMatterActionAndPerson AS P

and

qsumHoursRemainingByMatterAction  is A

qsumHoursRemainingByMatterAction AS A

Rocky Smolin at Beach Access Software wrote:
> SELECT P.MatterActionID, P.PersonID, P.HoursRemaining, A.TotalHoursRemaining
> FROM qryHoursRemainingByMatterActionAndPerson AS P INNER JOIN
> 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
>  
> 

-- 
John W. Colby
www.ColbyConsulting.com