Lobby - datasource join two views

Hello!

What results do you expect to see?
Do you want to see all customer order lines where qty_assigned > 0 and order_id = ‘ERS’?

Hi @jgrace ,

Here is what we usually do to create datasources using multiple views.

1. Create and deploy an IAL where you'll be placing your SELECT with all the joins required.
Path : Solution Manager > Reporting and Analysis > Information Access Layer > IAL Object

2. Create a quick information source draft from that IAL.
Path : Solution Manager > Reporting and Analysis > Information Sources > Quick Information Sources Drafts > Quick Information Sources

3. Create an information source from the drafted quick information source.
A view will automatically be created at this point. The view name can be obtained in the “Data Access Type Information” group. 
Path : Solution Manager > Reporting and Analysis > Information Sources > Information Sources > Information Source
You will be able to use the view in your datasource.

Regards,
Trishen

This is not an answer to the initial question, just a side note:

For those actually wanting to join customer_order and customer_order_line: There is already a view called CUSTOMER_ORDER_JOIN in STD that does that. It may or may not contain the columns you need.

For the real question:

If you only need to show data from one view and only need the other one to fetch the correct data you can also do an EXISTS or IN statement in the WHERE clause.