Skip to Content
avatar image
Former Member

information design tool table queries

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 14, 2017 at 04:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded