[AccessD] Query grid question

Charlotte Foust charlotte.foust at gmail.com
Tue Apr 5 18:19:03 CDT 2011


OK, there is no join between the tables and the you're aliasing fields
as well as tables.  You won't see any joins because you haven't
created explicit joins, only implicit in the Where conditions:

>  Members.PID=Groups.PID and
>  CM.PID=Members.ChildPID

That won't show up in the Access grid as joins.  Are you saying that
you don't see the field aliases in the grid?

Charlotte Foust

On Tue, Apr 5, 2011 at 2:03 PM, Kaup, Chester
<Chester_Kaup at kindermorgan.com> wrote:
> Here is a good example
>
> SELECT Groups.Name AS Manifold, Members.ChildPID AS API14, CM.Well_Number AS WellNo
> FROM GroupMaster AS Groups, ConfigMaster AS Members, dbo_DSS_CompletionMaster AS CM
> WHERE Groups.Name like "MANIFOLD *" and
>  Groups.Name not like "* AREA" and
>  Groups.GroupingType="CGRP" and
>  Members.ChildPTYPE="COMP" and
>  Members.PID=Groups.PID and
>  CM.PID=Members.ChildPID
> ORDER BY Members.ChildPID, Groups.Name;
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Tuesday, April 05, 2011 3:50 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Query grid question
>
> What does the SQL look like when you view that?
>
> Charlotte Foust
>
> On Tue, Apr 5, 2011 at 1:02 PM, Kaup, Chester
> <Chester_Kaup at kindermorgan.com> wrote:
>> I have a database in which a user has added some queries created in SAS. When I open the query in the design grid only the tables show up; no links between tables or grid with the table name, filed name condition etc. Any ideas what is happening?
>>
>>
>> Chester Kaup
>>
>> Engineering Technician
>>
>> Kinder Morgan CO2 Company, LLP
>>
>> Office (432) 688-3797
>>
>> FAX (432) 688-3799
>>
>>
>>
>>
>>
>> No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list