I'm using CR 10 and I am trying to write a SQL command. Sadly I'm only able to pull one table. When I try to link in a second table I get a FAILED TO OPEN ROWSET Error. It also mentions an extra token: OUTER
So It sounds like it doesn't like my JOIN statement
I can't seem to figure out the correct syntax to use for the join type. I tried using this format
SELECT "Customers"."FirstName", Customers"."LastName", ."SalesOrder"."Sales"
FROM "Customers" RIGHT OUTER JOIN "Sales"
ON "Customers"."CustomerID" = "Sales"."CustomerID"
I am going this route because I tried linking the tables by using the wizard and the report is unbelievably slow.
Any ideas would be greatly appreciated!