Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: while loops
10-24-2009, 11:10 PM #1
Ok so im pretty sure im not doing this right but im not entirely sure how i would go about doing it. so here is the problem.
Ive got 3 tables, aquired, songs, bracelets.
aquired consists of
id, uid, bid
and there will be multiple with the same uid but different bid.
SELECT * FROM aquired WHERE uid='123'
SELECT * FROM song, bracelets WHERE song.bid='3' AND bracelets.bid='3'
10-25-2009, 12:17 PM #2
- Join Date
- Mar 2007
- Thanked 2,216 Times in 2,203 Posts
- Blog Entries
Something like?Code:Select S.column_A,S.column_B, B.column_A,B.column_B from song as S inner join (bracelets as B, aquired as A) on (A.uid=123 and S.bid=A.bid and B.bid=A.bid)
The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)