Re: ACE Report Question (name, books, phone number)
OK, here's a revised suggestion including phone number:
database blah
end
select tab_1.name, tab_1.ID, tab_2.book, tab_1.phone
from tab_1, outer tab_2 { 'outer' if you want to list no-book people }
where tab_1.ID = tab_2.ID
order by ID, book
end
format
before group of ID
print " Name: ", name, " ID #:", ID
print "Books: ";
on every row
print book, 2 spaces;
after group of ID
print ""
print "Phone: ", phone
skip 1 line
end