[SQL] Need a VIEW without SUB-SELECT

[Bhuvan A]

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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])