Re: OUTER JOIN !!!!

In article <329377CD.772B@ece.uci.edu>, oten@ece.uci.edu says... >If your SQL server does not do outer joins but you need to combine >tables using the outer join method what should you do to substitute ? >I'll appreciate any kind of comments. Thank you ?-- What I would do is two seperate joins, and combine the results. The first join would grab all the data common to both tables. The second join would grab all the data that is in your primary table but not in the table you wish to relate to. When doing this, make sure you put correctly sized dummy values into the second join (since you can only combine the final results if they have the same structure). Not exactly nice looking code, but it does work. FWIW I've used this technique a lot under VFP 3.0, as that version of FoxPro doesn't support outer joins. As I said, the resulting code looks kludgy, but at least it runs.... Robert pearson@slh.wisc.edu