Hi, Does anybody know how I can join two tables via a full outer join when there are no common fields? I have two tables, one table has a "valid period" defined by a "date from" field and a "date to" field, the other table has a field with just one variable: "Statement Date". I want to join the two tables using a "where" statement, the "Statement Date" must be between the "Date From" and the "Date To" value. Because I don't have two common fields in the tables that I want to join, I get an error when I want to save the view without a join statement, but when I create the full join, I get an error because I don't actually name the fields to be joined. I can do this in EG, but I thought it would be a good idea to create a view using the "Prepare Data" option in SAS V.A. Best regards, Theun
... View more
