UNION query

weblike

Hi all,

I try to create a UNION query but only records from first BO are shown.

I have CompanyBO with attributes:

Name
Email

ContactPersonsBO with attributes:

Name
Email

The query looks like this
SELECT Name.CompanyBO, Email.CompanyBO FROM BSVname_CompanyBO
UNION
SELECT Name.ContactPersonsBO, Email.ContactPersonsBO FROM BSVname_ContatPersonsBO

The only results that are shown in the query are from CompanyBO...

Any help will be much appreciated.

Thank you

weblike

Hi all,

I have done this:

created a VIEW "union" in mysql
Created a BO in AWIM with external DB using this view.
Created a query to see all records..

All good by now...the query is displaying all the records from db (the ones I inserted in the view)

Now the issue:
I have an Invoice and I want to send email to the costumer and contact persons from this invoice.
IF I put in the query this ' FIND ContactsFromVIEW Where ContactsFromView.CustomerCode=ThisInvoice.Customer' I get no results and in AWIM server output I get this:
Invoice.Customer could not be resolved

Question: the attribute values are taken from context , right?Shouldn't the attribute Invoice.Customer to be taken from opened Invoice?

Any help will be much appreciated.
Now I want to create