Can anybody help me out with this query finaly I want to see all bookings between US clients and non US stockexchanges. But first i want to see all information in one report to be sure everything is correct.
I have a tables one is named bookings
NR ID Quantity SEC EXCHANGE
1001 1 1000 abc 5
1002 2 2000 def 6
1003 3 3000 ghj 7
1004 4 4000 klm 8
and a table names
ID Type country
1 Client US
2 Client US
3 Client US
4 Client CAD
5 EXCHANGE SP
6 EXCHANGE SP
7 EXCHANGE CAD
8 EXCHANGE US
I want to create a query where I can see also the countrycode I expect something like:
NR ID CntrQuantity SEC EXCHANGE CNTR
1001 1 US 1000 abc 5 SP
1002 2 US 2000 def 6 SP
1003 3 US 3000 ghj 7 CAD
1004 4 US 4000 klm 8 US
I have a tables one is named bookings
NR ID Quantity SEC EXCHANGE
1001 1 1000 abc 5
1002 2 2000 def 6
1003 3 3000 ghj 7
1004 4 4000 klm 8
and a table names
ID Type country
1 Client US
2 Client US
3 Client US
4 Client CAD
5 EXCHANGE SP
6 EXCHANGE SP
7 EXCHANGE CAD
8 EXCHANGE US
I want to create a query where I can see also the countrycode I expect something like:
NR ID CntrQuantity SEC EXCHANGE CNTR
1001 1 US 1000 abc 5 SP
1002 2 US 2000 def 6 SP
1003 3 US 3000 ghj 7 CAD
1004 4 US 4000 klm 8 US