I am having some problems with using join.
here's the tables:
t1 t2
MachineId MachineName MachID Service_Name
111 mach1 111 DHCP
112 SNMP
t4
Service_cat Service_name
Network DHCP
Email Exchange
Network SNMP
t4
Sevice_cat Doc
Network document
Email doc
Trainig doc
t4
SoftwareId Soft_Name MachineID
112 Exchange 111
I am getting all confused with too many tables. The goal is to make a list
of Machine and things running in to it. The database has two different table
for services and software.
First issue, not all services run in the machine, so thats one left join . I
figured that out. But then how would I handle both the service and software
table?
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.
Or Am i making this more complicated? Any hint will be great!
Thanks
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
