home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a061 / 1.img / CLIENT1 / ACT09A.QRY < prev    next >
Encoding:
Text File  |  1992-02-21  |  332 b   |  10 lines
  1. create proc pub_info 
  2.     @pubname varchar(40) = 'Algodata Infosystems' 
  3.     as
  4.         select au_lname, au_fname, pub_name
  5.         from authors a, publishers p, titles t, titleauthor ta
  6.         where @pubname = p.pub_name
  7.         and a.au_id = ta.au_id
  8.         and t.title_id = ta.title_id
  9.         and t.pub_id = p.pub_id
  10.