Thread: Create a temporary table in a function
View Single Post
  #5 (permalink)  
Old 01-21-10, 22:43
tcliam tcliam is offline
Registered User
  
Join Date: Oct 2009
Posts: 37
Quote:
Not at all, just move the query for the temp table inside the main query as shown in my first example.
Yes I did this but I am getting an error saying PreviousProject.MemberID doesn't exist. This is something that I have come a accross a number of times when using RETURN QUERY and assigning a name to a table like "PreviousProject". It always seems to say that the table doesn't exist.
If anyone knows why this would happen please let me know?

Thanks
Liam
Reply With Quote