Re: [GENERAL] Quetions on Joins

2003-09-01 Thread Alex
Ron, the idea is to provide a table where users can define filters. But it this table may be as well empty. Alex Ron Johnson wrote: On Sun, 2003-08-31 at 11:56, Alex wrote: Hi, I have a query where I want to filter out records from table_a if a field in table_a matches in table table_b. Ba

Re: [GENERAL] Quetions on Joins

2003-08-31 Thread Ron Johnson
On Sun, 2003-08-31 at 11:56, Alex wrote: > Hi, > > I have a query where I want to filter out records from table_a if a > field in table_a matches in table table_b. Basically table_b defines the > filter. > > If table_b however is empty i dont get any results > > SELECT A.value_one FROM table_a