Datasets!

[hussainian]

Hi!
I'm in a situation where I need some database fields which are not possible to get in the main query.

I throught that the datasets will solve my problem. But i just read that a dataset can only be used in a chart or a crosstab. Is it so? What is the alternative?

My problem is like

I have a report showing some columns (col1, col2) from a table and company name (companyName) from another table.

My query is

select A.col1, A.col2, B.companyName from TableA A, TableB B where ........

The problem is that in a scenario, where there are no rows returned from tableA, companyName field in the report is also null. I want that whether there are rows returned from a tableA or not, my company name must be displayed.

I guess I made my problem clear. Please give some suggestions.

Thanks & Best Regards.

AsadULLAH.

[hussainian]

Let me add one more thing that there is no relation between these two tables.

[lucianc]

hussainian
Wrote:

My query is select A.col1, A.col2, B.companyName from TableA A, TableB B where ........ The problem is that in a scenario, where there are no rows returned from tableA, companyName field in the report is also null. I want that whether there are rows returned from a tableA or not, my company name must be displayed.

Wouldn't an outer join work?

Regards,

Lucian