RE: struggling with select query

2007-02-27 Thread Gary W. Smith
> 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

Re: struggling with select query

2007-02-27 Thread Rolando Edwards
Detected Subject: struggling with select query Guys, Below is a select query which I'm stuggling with, so I'd be grateful for any help you could give me. select distinct TraderPersonalInfo.TraderID,PlatformMap.PlatformID from TraderPersonalInfo,Locations,PlatformMap,Platforms where (T

struggling with select query

2007-02-27 Thread lee_m4c
D*, 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