zeeshan jamal's Profile

About

 
Points: 5

Employment

 
Liveperson.com: 2014 - 2014

Pages

Contact

 

zeeshan jamal
November 4, 2014 · Public

The most difficult thing for programmers is to understand the code developed by the other programmers!isn't it?

zeeshan jamal
November 4, 2014 · Public

Hello world!
On buckys room!

zeeshan jamal
November 4, 2014 · Public

zeeshan jamal
November 2, 2014 · Public

So this is how i successfully able to retrieve the details about the winning bids in an auction system. With the details of that particular auction, particular item on which auction was started, particular auctioneer who started that auction, and a bidder who was awarded that bid.

So this is how,
"select * from APP.\"Product\" join APP.\"Auction\" on APP.\"Product\".\"productID\"=APP.\"Auction\".\"productID\" "
+ "join APP.\"Bid\" on APP.\"Auction\".\"auctionID\"= APP.\"Bid\".\"auctionID\" join "
+ "APP.\"AuctionBidderStatus\" on APP.\"Bid\".\"bidderID\" = APP.\"AuctionBidderStatus\".\"bidderID\" where APP.\"AuctionBidderStatus\".\"status\"='awarded' and APP.\"Bid\".\"bidderID\"="+userid

Buckys Fans
388 Followers
I am a developer
252 Followers