[AccessD] Query grid question

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