We need a report that shows perf_no, perf_code, perf_date and the name of the performance. We dont have a DBA on hand yet (we are interviewing) and I'm hopeful that someone has a similar query they wouldnt mind sharing. Thanks.
Enter your season ID(s) from TR_SEASON where I have "1,2,3" or just remove that line to view all seasons.
--
select a.perf_no,a.perf_code,a.perf_dt,b.description
from t_perf a
join t_inventory b
on a.perf_no=b.inv_no
where a.season in (1,2,3)
order by perf_code
thanks! I appreciate it...