Good afternoon all I have the below code:
All I want is to add the New Package.ID (Record/row) if greater than the New Package Port.NWID
This should be a peice of cake for you guys, assistance and guidance is greatly appreciated
PHP:
INSERT INTO [New Package Port] ( NWID, Title, Courier, [Inter Office], [No Lc], Reference, [Product Type], [Tracking Number], [LC 2], [LC 3], [LC 4], [LC 5], [LC 6], [LC 7], [LC 8], [LC 9], [LC 10], [LC 11], [LC 12], [LC 13], LCNum, LCRange, [LC 14], [LC 15], [LC 16], [LC 17], [LC 18], [LC 19], [LC 20], Created, [Created By] )
SELECT [New Package].ID , [New Package].Title, [New Package].Courier, [New Package].[Inter Office], [New Package].[No Lc], [New Package].Reference, [New Package].[Product Type], [New Package].[Tracking Number], [New Package].[LC 2], [New Package].[LC 3], [New Package].[LC 4], [New Package].[LC 5], [New Package].[LC 6], [New Package].[LC 7], [New Package].[LC 8], [New Package].[LC 9], [New Package].[LC 10], [New Package].[LC 11], [New Package].[LC 12], [New Package].[LC 13], [New Package].LCNum, [New Package].LCRange, [New Package].[LC 14], [New Package].[LC 15], [New Package].[LC 16], [New Package].[LC 17], [New Package].[LC 18], [New Package].[LC 19], [New Package].[LC 20], [New Package].Created, [New Package].[Created By]
FROM [New Package]
WHERE ((("where [New Package].[ID]") > "LAST [New Package Port].[nwid]"));
This should be a peice of cake for you guys, assistance and guidance is greatly appreciated
Last edited: