Does anyone know how to combine these two MySQL queries into one? create temporary table tmp_fs select * from fee_schedules where doctor_id=2;
select description from procedures left join tmp_fs on tmp_fs.procedure_id = procedures.id where tmp_fs.id is null; If you want to see the tables and some sample data, they're both here: http://www.hyperion-data.net/dbstuff.html I'm not using 4.1 so subselects aren't an option, sadly. Dan ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
