Combile Select Statements

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

welcome to sitepoint! :slight_smile:

what you want is called an inner join

hunnerts and hunnerts of sql tutorials on the web will explain it to you