MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Need to pivot a View, HELP!!!
Posted by: Aaron Marple
Date: May 12, 2017 08:48AM

This is the query....


SELECT

f.ffID,
a.asID,
f.label,
a.value

FROM `sixeightformsAnswers` a
LEFT JOIN `sixeightformsFields` f ON a.aID
WHERE f.ffID = a.ffID

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Need to pivot a View, HELP!!!
Aaron Marple
May 12, 2017 08:46AM
Re: Need to pivot a View, HELP!!!
Aaron Marple
May 12, 2017 08:48AM
Re: Need to pivot a View, HELP!!!
Peter Brawley
May 12, 2017 10:09AM


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.