homepage Welcome to WebmasterWorld Guest from 54.198.42.105
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
How to query Sub-queries in same table.
camilord




msg:3629450
 7:38 pm on Apr 17, 2008 (gmt 0)

can i do this?

SELECT * FROM transactions as t1 WHERE TotalAmount < (SELECT SUM(t2.TotalAmount) FROM transactions as t2 WHERE t1.TransactID = t2.TransactRefID) ORDER BY ActualDate DESC;

does it work? as i tested, no error.. but no result to.. all i know, it should have a results...

 

camilord




msg:3629835
 8:45 am on Apr 18, 2008 (gmt 0)

can anybody answer me please? please help..

thanks..

ashish21cool




msg:3630393
 10:28 am on Apr 19, 2008 (gmt 0)

First of all you dont need to add t1,t2. We name the tables as t1,t2....if there are more then 1 table.
try removing t1 and t2 and then fire the query.

SELECT * FROM transactions WHERE TotalAmount < (SELECT SUM(TotalAmount) FROM transactions WHERE TransactID = TransactRefID) ORDER BY ActualDate DESC

Let me know if it works or not

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved