Multiple Join Headache

Is there anyway in SELECt statement to tell, if service name is DHCP look into service table , if service name is exchange look into software table. Can i use something like this service.DHCP , soft.Exchange. You could use a UNION and then specify both queries if you're using mysql 4.0 i

Multiple Join Headache

I am having some problems with using join. here's the tables: t1 t2 MachineId MachineNameMachID Service_Name 111mach1 111DHCP 112SNMP t4 Service_cat Service_name Network DHCP EmailExchange Network SNMP t

Multiple Join Headache

I am having some problems with using join. here's the tables: t1 t2 MachineId MachineNameMachID Service_Name 111mach1 111DHCP 112SNMP t4 Service_cat Service_name Network DHCP EmailExchange Network SNMP t