Framework Manager 10.1.2 and Identifying the Right Row

[gosoccer]

Friends,
I have a small issue but it is taking us a while to figure it out.
Same table is used.

TABLE

MSES#           TYPE       STATUS   COUNT
1111               H              YES        1
1111               Z              NO         0[/u]

                       
So, the Framework Manager is to work in a way that it'll show the following
MSES#
1111               H               NO         0

So, basically, the result listing is showing the first row but including what
is collected from the second table.

Any help you can provide, I greatly appreciate it.
:( ::)

[Francis aka khayman]

sorry dude. you might need to explain it more clearly.

in any case FM do not behave like that. base on the information you provide, it will show the two rows of data from that table.

[gosoccer]

Well,
I'm using SQL within the Subject Query. The following is doing the trick

Using 2 table aliases from a same table named TESTING to retrieve the data

Code Select Expand

select MSES#,TYPE,STATUS,COUNT
from TESTING A, TESTING B
where (A.MSES# = B.MSES#)
Now, I need to specify one of them as the outer join or inner join.
I know this is not a SQL Forum but you do know how to have the above
SQL using a inner/outer join, please let me know.

Thank you

[Francis aka khayman]

a little bit clearer than the first post but still not quite.

anyway i would

1. create a Query subject in the database layer of the base table by either importing or using query.
2. create an alias (or two) from the same table, let's call them AliasA and AliasB
3. join AliasA to AliasB as needed.
4. create new Query subject taking what I need from the two alias table which I joined.

[gosoccer]

Thx a lot for your time.
Your suggestion should do the trick. I'll try it.