I have 2 tables I am pulling data from that I would like to combine
Table 1
Project Type
5884 Base
5990 Elec
Table 2
Project Eng
5884 Dan
5884 John
5884 Ben
5990 Scott
5990 Karl
I would like the query to return
Project Eng Type
5884 Dan Base
5884 John Base
5884 Ben Base
5990 Scott Elec
5990 Karl Elec