I have about a dozen concert id's of performances we did in 2009. Is there a simple query I can run that would be able to show me the performance detail (title, date, time) for a list of concert ID's (3678, 4247, 3745, 3743, etc) for a specific year (2009)? Thank you! Randy
Hi Randall
Something like this would work, if I understand you correctly::
select perf_no, perf_dt, inv.description
from T_PERF p
join T_INVENTORY inv on p.perf_no = inv.inv_no
where p.perf_no in (3678, 4247, 3745, 3743)
Ken
Thats perfect. thanks Ken!!!