What's the most concise way in sql to select from 5 different tables..
I want some data from each.. but mainly the telephone numbers found in each of these tables..
The ultimate goal is to create a type of phone book, so when someone searches in the phone number input box it returns all the phones numbers that match from those five different categories (tables).....
any help would be greatly appreciated.
Here's what i have now...
Thanks Nogdog, I'm still working on it... i see what you've done there...
Here's how I've done it:
$module = 'Phone Book';
$table = event_table('patient_dg()');
$alias = array(
$where_list = array();
$search = array(3);
$show = array(0,1,2,3,4);
$order = array(1);
$newlink = matry::base_to('phone_book/new');
$rowlink = matry::base_to('phone_book/lookup');
I'm only showing the phoneday input box which is what i wanted... but i still can't figure out how to get the other select (data) statements from the other tables to appear in my queries.