Greeting
im working with 2 tables
Table Store
Store ID | Store Name
1 | AAA
2 | BBB
3 | CCC
Table 2
StoreView
Store ID | NumberOfemployees
2 | 50
3 | 60
i want my out put to be something like this
Dimesnion Store
StoreID | StoreName | NumberOFemployees
1 | AAA | NULL
2 | BBB | 50
3 | CCC [ 60
any Query on how to do this ! i tried Union but it return for me "All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists."
Thanks in advance