Im attempting to pull a 5% sample from the resulting dataset of a table join. However, when trying to run this code I get an error. I believe its because the sample clause is getting confused as to which table to sample. Is there a way to get around this? What is the smartest way to get around this limitation of the Sample Clause?
Sample code below.
Thanks in advance.
SELECT a.Contact a.ContactNum b.Address c.Phone
FROM a.ExecInfo, b.Location, c.Demographics
WHERE a.LinkID = b.LinkID
AND b.LinkID = c.LINKID;