Studios Titles TitleID HP StudioID StudioName Address artistID Title City Region
ID: 3769090 • Letter: S
Question
Studios Titles TitleID HP StudioID StudioName Address artistID Title City Region StudioID PostalCode UPC Country Genre Web Address Contact EMai Phone SalesID Salespeople E3 SalesID Tracks 3 TitleID V TrackNum TrackTitle LengthSeconds FirstName Genre Last Name Genre Initials Base Supervisor MP3 RealAud Members F MemberID FirstName Last Name Address Artists ? ArtistID Xref Artists Members City Region Artist Name MemberID ? ArtistID RespParty PostalCode City Region Country HomePhone Countr WorkPhone WebA Address EMai Entry Date Gender LeadSource Birthday SalesIDExplanation / Answer
The required query is
SELECT StudioName FROM Studios
WHERE Region = "California"
UNION
SELECT LastName FROM Members
WHERE Region = "California"
The above query first fetches all studios which are in California . It also fetches lastnames of members in California. It make union of these 2 into a single list.