[AccessD] Query grid question

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Apr 7 07:41:44 CDT 2011


The query runs OK. The number of returned records is the same as what I would call a normal query. Something like this.

SELECT GroupMaster.Name, dbo_DSS_CompletionMaster.PID, ConfigMaster.WellName
FROM dbo_DSS_CompletionMaster 
INNER JOIN (ConfigMaster INNER JOIN GroupMaster ON ConfigMaster.PID = GroupMaster.PID) ON dbo_DSS_CompletionMaster.PID = ConfigMaster.ChildPID
WHERE (((GroupMaster.Name) Like "Manifold*" 
And (GroupMaster.Name) Not Like "*Area"));

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, April 06, 2011 10:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query grid question

The question that hasn't be asked is what kind of results you get if
you try to run the query.  What happens?  Do you get an error, do you
get a bunch of records in a cartesian product, or what?

Charlotte Foust

On Wed, Apr 6, 2011 at 5:38 AM, Kaup, Chester
<Chester_Kaup at kindermorgan.com> wrote:
> The grid is completely empty except for the two tables.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Tuesday, April 05, 2011 6:19 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Query grid question
>
> 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
>>
>
> --
> 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