SQL fails
Sama34 Offline
Senior Member
****
Posts: 490
Joined: May 2011
Post: #5
RE: SQL fails
So I would need to filter the scan in the inner select WHERE statement? But the only filters I can use are "rid (reputation type, in this case 'installs')" and pid (which should be the same as 'firstpost'), but that last is already being used in the ON (...) statement. Will "firstpost" work in the inner select? Will try as soon as I can connect to the FTP.

Support PM's will be ignored. Yipi
Plugins: Announcement Bars - Custom Reputation - Mark PM As Unread
(This post was last modified: 08-22-2012 06:23 PM by Sama34.)
08-22-2012 06:22 PM
Visit this user's website Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
SQL fails - Sama34 - 08-22-2012, 09:13 AM
RE: SQL fails - ZiNgA BuRgA - 08-22-2012, 10:36 AM
RE: SQL fails - Sama34 - 08-22-2012, 12:59 PM
RE: SQL fails - ZiNgA BuRgA - 08-22-2012, 02:13 PM
RE: SQL fails - Sama34 - 08-22-2012 06:22 PM
RE: SQL fails - ZiNgA BuRgA - 08-23-2012, 08:32 AM
RE: SQL fails - Sama34 - 08-25-2012, 04:24 AM
RE: SQL fails - ZiNgA BuRgA - 08-25-2012, 11:30 AM
RE: SQL fails - Sama34 - 08-25-2012, 04:52 PM

 Standard Tools
Forum Jump: