viewing a join in an existing query

[rosey99]

I am trying to recreate a query based on one that already exists. I will admit up front that I have not gotten very much training with joins, so any help with this would be greatly appreciated.

I would just like to know how do I view the join that exists in a query.  what do I click on? I have tried everything, looked in help and cannot find it. I am told this is not a typical join so I'm attaching a picture of it.  In a typical join you see the icon with the yellow boxes in between the queries, this one is just an arrow and you can't click on it. any help is greatly appreciated.  Thanks in advance!!

[tjohnson3050]

The picture you attached is not a join.  It is one query being sourced from one other query.  They are not joined in any fashion.  The results from Claim RC are the source for Claim Detail.

[rosey99]

The picture you attached is not a join.  It is one query being sourced from one other query.  They are not joined in any fashion.  The results from Claim RC are the source for Claim Detail.

okay, that helps. can you tell me how I create this in my other query? in other words, how do I create the same sort of thing but with different tables/fields? do I drag one query into the other? or??

thank you.

[tjohnson3050]

You drag the source query just to the right of the target query.

[blom0344]

I am trying to recreate a query based on one that already exists.

In SQL / query terms this would be a CTE (common table expression) or an 'inline view' Cognos uses query reference, which is also a good description..

[rosey99]

You drag the source query just to the right of the target query.

thanks! I am getting there but still not quite there. I noticed in the other one that I'm trying to emulate that field that normally would be linked (claim #) is a filter in the target query but I am not sure how to get it in there as a filter. I tried dragging that field from my source query into the target query but it won't let me do that.  I'm attaching what that filter looks like in the query that works.

thanks for the help, appreciate it!!

[rosey99]

by the way, I typed the filter just like my most recent attachment shows, clicked the "validate" check mark and no errors were found.  but I'm still not getting the results I need.

any help is greatly appreciated!

[tjohnson3050]

If possible, you should always do the filtering in the source query, not the target query.

If you have to put the filter in the target query, it should be as easy as dragging the data item from the source query into the filter pane in when editing the target query.

[rosey99]

If possible, you should always do the filtering in the source query, not the target query.

If you have to put the filter in the target query, it should be as easy as dragging the data item from the source query into the filter pane in when editing the target query.

okay, thanks. I will continue playing with it.  appreciate it!!