MySQL Forums :: Views :: Join with a View

Advanced Search

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
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 4510 Albert Stewart 01/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.