Re: Combining two SQL Statements

"Michael" <gonnot_at_gmx.de> wrote in message news:89cf72b0.0410070017.26d34736_at_posting.google.com...
> Hello,
> I need to combine this two SQL-Statements to one SQL:
>
> 1. select UserId, UsedSlots from user_used_slots;
>
> UserId UsedSlots
> a 3
> b 5
> a 4
> c 3
> b 5
>
> 2. select UserId, FreeSlots from user_free_slots;
>
> UserId FreeSlots
> a 4
> b 5
> b 3
> c 3
> b 5
>
> ==> The resulting SQL-Staetement should show something like this:
> (TotalSlots = UsedSlots + FreeSlots)
>
> UserId UsedSlots FreeSlots TotalSlots
> a 7 4 11
> b 10 15 25
> c 3 3 6
>
> How can I produce a Output which calculates everything correctly??
> Thanks,
> Michael

select a.userid,a.usedslots,b.freeslots,(a.usedslots+b.freeslots) totalslots from user_used_slots a,user_free_slots b where a.userid=b.userid Received on Thu Oct 07 2004 - 06:13:11 CDT