Join with a View
Posted by: Albert Stewart
Date: January 10, 2013 02:33PM
Using 5.5 I created a View with WorkBench:
CREATE OR REPLACE VIEW `rxcds_db`.`ViewRenalData` AS
SELECT Patient.Acct, Patient.LastName, Patient.FirstName, Patient.Loc, Patient.Age, Patient.Sex, Patient.Ht, Patient.Wt, Lab.LabID, Lab.CreatTime, Lab.Creat,
FROM (Lab INNER JOIN
Patient ON Patient.Acct = Lab.Acct);
The SELECT .... returns a table of data fine, but if I
"select * from ViewRenalData;" the returned table has no data.
I also note that in WorkBench the ViewRenalData displays as a View in Model Overview, but is listed as a Table in the Object Browser of the Sql Editor.
Please advise. Why doesn't "select * from ViewRenalData" return data ?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.