Welcome brother !

...AND Ships.Dest_State IN ('LA') ORDER BY 'PU_Date' ASC
The ASC is out of the quotes, what's in the quotes is the column name !

Don't forget to mark as solved, if solved ;)

AND Ships.Dest_State IN ('LA') ORDER BY 'PU_Date ASC'
In this last line, you have i think mistakenly put the keyword ASC as part of the column name. Try removing the ASC from the quotes !

else you can specify a second different table in the fk constraint e.g. rather than fk_table1_table1(column) make it fk_table1_table2(column)

hi Br1Dil,

Well from first looks, the last column you added has a foreign key constraint referencing the same table. Is that constraint necessary ? I don't think so. Try commenting it out, or...