Was wondering if this is doable in an oracle database?

Thank You Very Very much!

That's a good one. No this is not a H/W Question.

We have a case where we need to get all the records which has a specific criteria. I had generalized...

Thanks for your response.

Thanks it worked...

Thanks guys. Appreciate your help.

Thanks for the reply. The distinguishing feature of the dummy course is that all the students in the system will be assigned to that dummy row.

Hah... I forgot to post what the question was..

I need to write a query to find out the dummy rows if they exist...

John , Srijith

          Thanks for your help.

A-

These are external table for me and i do not have access to modify these tables. I have select permission from those two tables.

Ashok

My current query looks like this ...

select a.aid, a.aname, a.comments as commets, b.acommnets as updatedcomments from

TABLE A LEFT JOIN  TABLE B on a.aid = b.aid

where do i put the IF...

This solution seems to be working for me.

Thank you!

First of all thank you for your help.

This solution that you had proposed works partially. The query will return id, name, tracking_number and start_date for the record whose starting date...

There is a small issue with the query. The inner query  "(select a.id,a.name,a

Gopi. Thanks for your response. Your solution worked!

Thanks a lot

Ash-