Skip to Content
0

information design tool table queries

Jun 06, 2017 at 02:33 PM

36

avatar image

Hi,

Have following situation.

run table with 1 run (driver in vehicle) makes 2 calls at shops ( calls table), 1 call to pick up 2 parcels, other to pick up 1 parcel i.e. 3 parcels in total (i.e 3 parcels in total) these 2 calls are associated with 2 different customer orders ( i.e. 2 rows in customer orders table)

If want to show these in 1 query such that can see the 3 parcels and the 2 diffreent customer to whom they belong how is this bets achieved

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Jun 14, 2017 at 04:49 PM
0

Hi,

Looks like 1 to N from Vehicle to Caller table and N-N between Caller and Parcel table.

Apply these joins in Data foundation layer and do a quick query to validate the results.

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded