Hello - I'm a little rusty on my SQL, and I have an inner join that I need to modify to add an extra table and field to it, and am getting syntax errors. I'm attaching a text file with the SQL in it, which is the SQL from the design of an existing view in the database. I basically need to join an additional table called CUSTPACKINGSLIPJOUR to the first table in the view (SALESDATA) on the "salesid" fields, so that I can also pull a field called "packingslipid" in the view. How do I do it so that it doesn't cause duplicate lines that are unnecarry in the view?
Thanks for your help