Dynamic SQL - From clause

[Pamela Lantzy <PLantzy@UAMAIL.ALBANY.EDU>]

I have seen this in a couple SQRs, but I am not sure what this does.


FROM [PS_COMMUNICATION:$table] V

$table gets populated with a different table name.  There isnt a comma to
separate the 2 tables.  In the where clause there is nothing that joins
these 2 tables together.

Is if $table is not assigned a table name then it will use PS_COMMUNICATION
as an alternative, but if $table is assigned, it will use that and ignore
PS_COMMUNICATION?


I couldnt find any explainations of using : in the from.

Thanks.
Pam