MySQL Forums
Forum List  »  Views

Workaround for subquery limitation in in view creation
Posted by: TAMIL SANKARALINGAM
Date: May 25, 2014 10:30AM

Hi All,

I need to formulate the view based on these two tables. Firt table's unique key will be having more than one entry in second table. So we need to use the sub query to formulate the unique entry for each resource group entry for that view. But the sub query is not allowed in the from clause of the view.

Could you please share any work around to create the view for this scenario.
Given my scenario. Student name can have more than one entry in the second table.

StudentName Description
name1 test
name2 test

StudentName Subject Marks
name1 Tamil 80
name1 English 80
name2 Tamil 70
name2 English 89

StudentName Description Subjects Marks
name1 test Tamil,English 80,80
name2 test Tamil,English 70,89

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Workaround for subquery limitation in in view creation
4819
May 25, 2014 10:30AM


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.