Forum Discussion
creating a good data set
hi
thanks for the reply..
i have a view that looks like so:
app code, buyer name
lets take an expample
app code,buyername
123,john
123,kate
123,ron
when i take this view and join it with itself (is that what you meant when you said merge query?) i get
123,john,123,kate
123,john,123,john
123,kate,123,john
123,kate,123,kate
i used the app code as the join parameter
i also have unique buyers and uniqe app tables.
i would be happy to follow your lead...
thanks
Hi tamirka,
Based on your disription, you and your wife buy one department, and your wife and his mother buy other one. How identify the raltionship between them, you and your wife, your wife and her mother.
In actual life, many people buy same one apartment. For example, john, kate and ron buy 123 app. You select john and the report to show kate and ron buy the same app. If kate and join buy one department rether two departments, how do you identify the relationship?
Thanks,
Angelia Zhang
hi
i donwt understand your question.
what do you mean with 'In actual life, many people buy same one apartment'?
me and my wife buy this app and she and her mother buy another one.
the difficult part is how do i connect myself with her mother?
Hi tamirka,
To put it in another way, for the following instance, john and kate buy same 123. Relationship between you and your mother is similar to the relation between john and kate, right?123,john,123,kate
123,john,123,john
123,kate,123,john
123,kate,123,kate
Best Regards,
Angeliayes...
and thats not what i want...