Good evening. I can do very basic sql syntax. I currently have the following which gives me the result of two tables.
FROM DELTEK.MO_HDR MH
WHERE MO_ID = 'MO-0010720'
FROM DELTEK.SO_LN SL
WHERE SO_ID = 'SO-0000954'
One table is sales order header lines and the other is for material orders. I would like to combine these two tables. Essentially the sales order table can have many lines with the same sales order number, there can only be one material order associated with the sales order number. The same would be true for the BLD_PROJ_ID field. I hope that makes sense. I attached a screen shot if that helps.