as a *AND*, not *OR* as above.
Any help would be greatly appreciated.
Cheers.
- Lee.
--
View this message in context:
http://www.nabble.com/struggling-with-select-query-tf3300643.html#a9181415
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http
as a *AND*, not *OR* as above.
Any help would be greatly appreciated.
Cheers.
- Lee.
--
View this message in context:
http://www.nabble.com/struggling-with-select-query-tf3300643.html#a9181415
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
select distinct
TraderPersonalInfo.TraderID,PM2.PlatformID,PM4.PlatformID
from TraderPersonalInfo,Locations,Platforms PF2,Platforms PF4,
PlatformMap PM2,PlatformMap PM4
where (TraderPersonalInfo.TraderID = PM2.TraderID)
and (PM2.PlatformID = PF2.PlatformID)
and PM2.PlatformID = 2
and