Re: sql question
Date: Fri, 30 May 2008 12:49:30 -0700 (PDT)
On May 30, 1:58 pm, zamba <CRISTIAN_FERR..._at_hotmail.com> wrote:
> Hi..i have this trouble ....
> i have table A wich this data
> cod_group bill_type
> GROUPA BILLTYPE1
> GROUPA BILLTYPE2
> GROUPB BILLTYPE1
> GROUPC BILLTYPE2
> GROUPC BILLTYPE3
> THEN i have 3 tables
> TABLE NOTICE wich have this field : notice_number
> TABLE NOTICE_BILLS wich have notice_number , bill_number
> TABLE BILLS wich have bill_number , bill_type
> i wish to get all the NOTICE wich have exactly the same bill type in
> its bills that the group i send as parameter.If group have 2 types,
> notice must have 2 bills with the same code, if group have 1 type,
> notice must have 1 bill with this type
> NOTICE 1
> BILL100 (BILLTYPE1)
> IF I SEND PARAMETER GROUPA , GROUPB OR GROUPC NO ROWS MUST RETURN
> because the combination doesn't exist in any group
> if ihave
> IF I SEND GROUPA , no rows must return, because group a have
> BILLTYPE1 AND BILLTYPE2, but if i send GROUPB , must return a
> thanks !!!!!!
It's too bad you didn't include the entire homework assignment in your post ...
So, what have you tried to solve this problem? Post what you've done and we'll give advice. We won't do your assignment for you.
David Fitzjarrell Received on Fri May 30 2008 - 14:49:30 CDT