Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL Select multiple distinct
- SELECT DISTINCT b.user_id, b.auction_listing
- FROM AuctionBids b
- JOIN Auctions a USING (auction_listing)
- WHERE a.end_datetime < NOW() + INTERVAL 24 hour
- SELECT b.user_id, b.auction_listing
- FROM AuctionBids b
- JOIN Auctions a USING (auction_listing)
- WHERE a.end_datetime < NOW() + INTERVAL 24 hour
- GROUP BY b.user_id, b.auction_listing
Add Comment
Please, Sign In to add comment