[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Multiple Join Headache
From:       Christopher Book <cbook () rim ! net>
Date:       2001-10-31 18:15:59
[Download RAW message or body]

>>>>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
ie select ..join with tablea.... where servicename=dhcp UNION select ...join
with tableb... where service name=exchange.
Chris

---------------------------------------------------------------------
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 <mysql-thread89631@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]