Re: table join trouble

2008-01-06 Thread Shawn Green
Hi Edward, (see below) Edward Corbett wrote: Hi, I am trying to join a bunch of tables together. I want a row for each "learner", and on the row, I want some "user", "centre", "client" and "centreManager" information if there is any. Thus, I am trying to outer join from the "learner" table t

table join trouble

2008-01-03 Thread Edward Corbett
Hi, I hope this finds itself as an answer to my last post. I'm new to this email message format of lists. It turns out that the problem with the join was that I had a column being selected that I removed from my posting example for brevity which was causing the select to fail. The extra c

table join trouble

2008-01-03 Thread Edward Corbett
Hi, I am trying to join a bunch of tables together. I want a row for each "learner", and on the row, I want some "user", "centre", "client" and "centreManager" information if there is any. Thus, I am trying to outer join from the "learner" table to 4 other tables. The query I have so far is bel