https://communities.sas.com/t5/SAS-Enterprise-Guide/Weird-SQL-problem/m-p/4154#M1322 Hmm, you say you are creating an empty set, but I don't actually see where you are creating anything but a list output. Are you sure you are not constantly looking back at the same unchanged empty table?<BR /> <BR /> I would have expected the syntax " Select *" to be preceded by something like "Create Table RESULTS As".<BR /> <BR /> If you rewrote your syntax and missed a line, then please set the options "_Method STimer" on the SQL Procedure call and just send us the log excerpt so we can see what methods were called, how long it took and what was created.<BR /> <BR /> Kind regards<BR /> <BR /> David Mon, 13 Aug 2007 05:31:47 GMT deleted_user 2007-08-13T05:31:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Weird-SQL-problem/m-p/4153#M1321 Everything is very simple - I am trying to match two lists, say List1 and List2, each of which contains last names...<BR /> <BR /> I am using the following:<BR /> <BR /> proc sql;<BR /> select *<BR /> from List1 as p, List2 as r<BR /> where p.lastnamefromlist1 = r.lastnamefromlist2;<BR /> quit;<BR /> <BR /> And the result is empty set, but List1 and List2 have the same data. Weird thing is that I ran this code before and produced the right results. I am not sure what is going on??? Any ideas? Fri, 10 Aug 2007 19:21:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Weird-SQL-problem/m-p/4153#M1321 deleted_user 2007-08-10T19:21:05Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Weird-SQL-problem/m-p/4154#M1322 Hmm, you say you are creating an empty set, but I don't actually see where you are creating anything but a list output. Are you sure you are not constantly looking back at the same unchanged empty table?<BR /> <BR /> I would have expected the syntax " Select *" to be preceded by something like "Create Table RESULTS As".<BR /> <BR /> If you rewrote your syntax and missed a line, then please set the options "_Method STimer" on the SQL Procedure call and just send us the log excerpt so we can see what methods were called, how long it took and what was created.<BR /> <BR /> Kind regards<BR /> <BR /> David Mon, 13 Aug 2007 05:31:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Weird-SQL-problem/m-p/4154#M1322 deleted_user 2007-08-13T05:31:47Z