On 17 Oct 2002 at 12:05, Mark Patterson wrote:

>I was trying to add a field to indicate whether the user had selected
>a field or not. To make it transient and not takeup space in the table
>I added a table sm_selected with one field called id. The presence of
>value in sm_selected means that the corresponding record in sawmembers
>has been selected by the user and is hightlighted on his screen.

I think in your case full join is unnecessary. Try to use left
join.

SY, Dimitry Sibiryakov.