MySQL Forums
Forum List  »  Views

Join with a View
Posted by: Albert Stewart
Date: January 10, 2013 02:33PM

Using 5.5 I created a View with WorkBench:
USE `rxcds_db`;
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,
Lab.BUNTime, Lab.BUN
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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Join with a View
4593
January 10, 2013 02:33PM


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.