CREATE VIEW status_schmetus AS SELECT approval.status_name AS aproval_status_name,
acknowledgement.status_name AS acknowledgement_status_name FROM po_status JOIN status
AS approval ON(po_status.approval_status_id = status.status_id) JOIN status AS
acknowledgement ON(po_status.acknowledgement_st
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
