On Sat, 2004-01-10 at 18:43, Daniel Crookston wrote: > 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;
No. Those two queries cannot be combined. Please explain what you're trying to do and why you think you need them merged and perhaps we can figure out a solution for you. Corey ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
