Skip navigation links

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
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 1200 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.