Re: return null fields ok
Code:
select table1.field1, table1.field2, table2.field1, table2.field2
from table1, table2
where
table2.fieldc = 5 and
table2.fieldd = table1.fieldd
group by table1.field1, table1.field2, table2.field1, table2.field2
- petter
Re: return null fields ok
It does not make sense to me. U R using "GROUP BY" without any agregate function (like SUM,COUNT etc).There are no errors but it doesn't mean that it works! U can skip "GROUP BY".
And I don't understand what U are trying to achieve. Is it OUTER JOIN U looking for?
Best regards,
Krzemo.
Re: return null fields ok
First off let's see what yo are after. Can you post an example of the table data and what yu expect the results to be. Also, you are using the older ansi join syntax method which most databases have moved away from to the newer INNER JOIN, OUTER JOIN options, what system are yu developing against?