[AccessD] Alias Table Name

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