Need a VIEW without SUB-SELECT

Hi all,

Kindly apologize any inconvenience!

I have 2 tables status and po_status like..

CREATE TABLE status (
status_id int primary key,
status_name varchar(15)
);

CREATE TABLE po_status (
po_no varchar(15),
approval_status_id int references status(status_id),
acknowledgement_status_id int references status(status_id)
);

Right..

Now, how can i have a VIEW on po_status table to get
'approval_status_name' and 'acknowledgement_status_name' instead of
approval_status_id and acknowledgement_status_id?

I am sure that a VIEW with SUB-SELECT will solve everything. But my QB
won't support SUB-SELECT and i wasn't ready to redesign my QB, which
is a time consuming process.

How can i accompolish this ????

Thankx in advance.

======================================================================
Kime's Law for the Reward of Meekness:
Turning the other cheek merely ensures two bruised cheeks
======================================================================

Regards,
Bhuvaneswar.