Skip to Content
Former Member
Jul 09, 2009 at 06:15 PM

SQL Command and JOIN Types


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!