Table 1 - houses all user information
Table 2 - houses all counts for the users
Table 3 - houses all user info. for those users that are unique.
I have three parameter ID, Status and Group
I am trying to figure out how to write my query so that if a user
selects a set of 3 parameters it pulls from Table 1 for example and if
he/she chooses another set of 3 parameters it pulls from table 3 ect.
Here is my query that hopefully someone could help me finish. I am
using oracle 9.2
Table 1 a
LEFT OUTER JOIN
Table 2 b
a.id = b.id
RIGHT OUTER JOIN Table 3 c
a.id = c.id
a.id in ID
a.status in STATUS
---- this is where I seem to be stuck---------------------
if Group = 'ALL' then pull user info. from Table a
if Group = 'ATT' then show users in table 3 where there status in
table 1 = 'DONE'
if Group = 'NULL' then look at all the users in table 1 and remove
those that are the same in table 3(since table 3 will house users that
are also found in table 1 but that are unique) and display the results
of table 1
If someone could figure this out this would be most appreciated.