Ichiro still climbing the charts.

Answer changed and points awarded back.

I don't know why I use dw. Old habit. I'll try to stick to the longer syntax in the future as a better example.

Here's the issue, ahmed_elbarbary.2010. You have a query there, but you need to explain why it doesn't work. I don't want to dig through a long result set and try...

Closing: post replies here: https://www.sqlservercentral.com/Forums/1884715/How-to-make-relation-between-tables-to-calculate-cost-of-flight-and-transfer-and-hotel-and-excursion?Update=1#bm1884820

Closing: post replies here: https://www.sqlservercentral.com/Forums/1884715/How-to-make-relation-between-tables-to-calculate-cost-of-flight-and-transfer-and-hotel-and-excursion?Update=1#bm1884820

Closing. Please post replies here: https://www.sqlservercentral.com/Forums/1884715/How-to-make-relation-between-tables-to-calculate-cost-of-flight-and-transfer-and-hotel-and-excursion?Update=1#bm1884820

And post your attempt. Again, we are not here to do your work.

Everyone, please  DO NOT post a solution if there is no attempt by the OP.

I used Arrays, since this somewhat corresponds to what others would see in their language.

This doesn't show what you've tried. Put data in the tables, post the inserts, and post some queries that retrieve data.

We are here to help, but not do...