Left Joins in SQL 9.0 versus Xbase

[Tom_Mills]

I^m a long time xbase user, currently on 9.0. I use Access a lot also, so I just ordered a copy of 9.0 SQL.____I hit a wall almost immediately. One that^s so basic I can^t believe it^s not me doing something wrong.____Let^s say I have a master datafile full of ID numbers. I want to report on 3 related tables. We^ll say one is CD^s people own, the next are cars they own, the third is their pets.____In xbase, I^d do a scan of all the files from the master, and tell it that the failure action was blank.____In SQL when I tried the same thing, I could do a left join on the first table, but it forced me to do equi-joins on any subsequent tables. This of course means that if they don^t show up in a table, they are out of the report.____Am I doing something wrong? If not, this is a "show-stopper" for me.____I even tried pasting in the SQL statment from Access (that works) but got an error.____What^s the story? Don^t make me learn Crystal!!!

[kfleming]

One way around this would be to create an Access query for the joins and then use that query as the master table in R&R.____The other option is to build a user SQL report in R&R where you would write the SELECT statement.____For your table structure a UNION would probably be the appropriate SQL construct and that would require a user SQL in R&R.______Kathleen__R&R Support