advise on sql query....
Posted on 1999-07-01
i am very confused while creating the following output on 2 tables:
show all active conferences at the time of customer evaluation, but indicate [with a flag]
if customer has already regestered for a conference. in other words if we have total of 13
conferences active, i have to show all 13 conferences. but if a customer has registered
for one or more of currently active conferences i have to mark it as not available, but
still show. i think all i need in my select statement are:
conference_id, conference_name, is_registered.
one important thing which makes this very complicated - customer is questions may and
may not exist in table2 - customers are being recorded in table 2 only when registered for
at least one conference.
please help. will give away all my points! :)