OTBI - add a SQL column to a subject area analysis

Summary

Can you refer to a table using SQL and a subject area at the same time?

Content

Is it possible to add column to a subject area using SQL?  I have tried editing the XML in the 'Advanced' tab, and using the SQL created the system in a new analysis without luck.

If it is possible, presumably it is using the 'Advanced SQL Clauses' section?

Many thanks