"Thalis A. Kalfigopoulos" wrote:
> Check you don't have empty strings as empty remarks, but that you have NULLs.
> Even with empty strings as remarks though you can bypass them with an extra WHERE
>condition :-)
That was it. I was storing empty strings, instead of NULLs. Thanks!
AMK4
On Thu, 5 Apr 2001, Ashley M. Kirchner wrote:
> "Thalis A. Kalfigopoulos" wrote:
>
> > > +--++--+-+
> > > | task | comment |remarks | history |
> > > +--++--+-+
> > > | task_1 | cmt_1
"Thalis A. Kalfigopoulos" wrote:
> > +--++--+-+
> > | task | comment |remarks | history |
> > +--++--+-+
> > | task_1 | cmt_1| rmk_1| |
> > | task_1 | cmt_2
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote:
>
> Db -> table1, table2 and table3
>
> SELECT table1.task, table2.comment, table2.remarks, table3.history
> FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
> LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
>
> Resul
Db -> table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
+--++--+-
