Database

SELECT supplier.sname, failures.count, supplier.count
FROM
(
    select suppliers.sname, count(*) AS count 
    from failures,devices,suppliers 
    where devices.suppid=suppliers.suppid 
    and failures.deviceid=devices.deviceid 
    group by suppliers.sname
) AS supplier
INNER JOIN
(
    select suppliers.sname, count(*) AS count 
    from devices,suppliers 
    where devices.suppid=suppliers.suppid 
    group by suppliers.sname
) AS failure ON supplier.sname = failure.sname

Colin Angus Mackay wrote:

Does this help?

SELECT failure.locid,device.count [devices],failure.count [failures]<br />
FROM<br />
{<br />
select locality.locid,count(*) from allotment,locality where allotment.locid=locality.locid group by locality.locid<br />
} AS device<br />
FULL OUTER JOIN<br />
{<br />
select locid,count(deviceid) from failures group by locid<br />
} AS failure ON device.locid = failure.locid

karinb wrote:

he designer keeps defaulting to a length of '16'

karinb wrote:

I am actually copying/pasting text from a document and it includes some html tags. would that cause a problem?

kam_ps wrote:

1.Does Dataset class of ADO.Net support nested tables ?

kam_ps wrote:

3.If not,how to manipulate nested tables of Oracle in ADO.Net?

Darpan Gogia wrote:

There is nothing like nested table in ado.net. But, the solution is there where the relational features of dataset comes in picture.