Subject Nested Joins or Temp Tables
Author gymbratjodee
Hey. FB Newb here. Come from strictly a SQL Server background. I am attempting to optimize some queries and procedures by either

A) Creating a temp table, inserting key values from a small set of records, then using the temp table as my initial join for child tables


B) Using a nested select (derived table) to essentially do the same thing

I can not seem to find anywhere online whether this is even supported and if it is, the correct syntax. We are using FB 1.5.

Any help is greatly appreciated.