Re: [SQL] views and null bothering

2001-08-07 Thread Martín Marqués
On Lun 06 Ago 2001 21:02, Josh Berkus wrote: > Martin, > > > I have a bunch of tables which I give access through a view. The > > problem is > > that in the main table there are columns, that are referenced to > > another > > tables column, that have NULLs. > > In the SELECT inside the view's defi

Re: [SQL] views and null bothering

2001-08-06 Thread Josh Berkus
Martin, > I have a bunch of tables which I give access through a view. The > problem is > that in the main table there are columns, that are referenced to > another > tables column, that have NULLs. > In the SELECT inside the view's definition I put the join equality, > but have > lots of trou

[SQL] views and null bothering

2001-08-06 Thread Martín Marqués
I have a bunch of tables which I give access through a view. The problem is that in the main table there are columns, that are referenced to another tables column, that have NULLs. In the SELECT inside the view's definition I put the join equality, but have lots of trouble makeing it put correc