• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 3 views
  • Users 0 members are here
Related

list concert titles by concert id

Randall Mitchell
$organization

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

Parents
  • Former Member
    Former Member $organization

    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

     

Reply
  • Former Member
    Former Member $organization

    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

     

Children