SQL Query Urgent

[vraj_chowdary]

Hai Every one
I need one SQL Query
Consider 2 tables A,B.
They have one column called status
User Enters one GroupId in From and click on search button
Tht group id must be there in any one of the table.
If groupID in Table A then it has to retrive the status from Table A.If the GroupID in Table B then it has to retrive status from Table B.
This is my requirement.
Can any one help me to find the query

[johnbol]

I have tested this one, and below is my solution. As far as I understand it, group_id is a unique value in both tables, therefore giving one status per group_id. This works for my oracle database.

regards,

John

select nvl(
(select status from a where group_id = <group_id>),
(select status from b where group_id = <group_id>)
) from dual

[shkumar]

Hope this will give your result..

select a.col1,a.col2,(case when a.group_id = <groupid> then
a.status
when b.group_id = <groupid> then
b.status
else
null
end) status
from a,b
where a.col1=b.col1;

regards

Hari

[zameersait]

You may this the following solution.

select status from
(
select status,group_id from a
union
select status,group_id from b
)
where group_id = <groupid>;

Regards
Zame