I have 3 tables:
- work (workID, description)
- machine (machineID, name)
- work_machine (machineID, workID, hours)

What I want is to obtain a result similar to:

work, machine1, machine2
A , 1 ,
B , 3 , 5

The problem is that the number of works and the number of machines is unknown.

Can anyone help?

A small Query ,I need to know how can I notify a new row entry in a table.

to be more specific I have a table Users If at all a new users registers from web his details are stored in database.
i would like to know is there any way to knwo the new row entry.

If so please let me know.

Sam

I am new to sql programming, How can we copy a database from a local system to server?

Thanks in advance,
karthik.

Is there any in built debugger tool present in SQL Server for PL/SQL programs? Or can we configure a new debugger tool like SQL*Debug for Oracle? I need your help for this.

waiting for your reply