Addressing FileGroup Tables & Fields

[stanlyn]

Hi,

I have a databse that contains 3 filegroups and was wondering how to reference them via the select statement like:

select field1, field2, FileGroup1.FileGroupTable.FileGroupField1 from both the MyTable and the FileGroup1 Tables
and ordering them by FileGroupField1 and field1.

Note that field1 and 2 are from a table in the Primary FileGroup.

Thanks, Stanley

 

[stanlyn]

Figured it out... Treat it like an other field as there is no reference needed for the file groups.

Stanley