Looked up the mySQL docs and found my own answer. I think I am becoming an expert, hehe...
I will post my answer for future reference by others. RCQit sql="select personnel.NAME,pcnodelist.TRACKING,pcnodelist.MODEL,pcnodelist.SN,pcnodelist.MONITOR_SN,pcnodelist.OFFLEASE_DATE,pcnodelist.Price from personnel, pcnodelist where pcnodelist.PERSONNEL=personnel.ID AND pcnodelist.BC = 'RC$bc' order by pcnodelist.OFFLEASE_DATE asc" Keff "Keff Edwards" <[EMAIL PROTECTED]> wrote: > >Yo's People! > >I have 2 tables (Users, Computers). A field in computers (userID) relates >to the auto increment no duplicate field in USERS labeled ID. I need to >run a simple Output Query that Displays my computer Information out of the >Computer DB but also displays the USername for that computer in th USER database. > I know that Nested SQL is not allowed but is there a way to do it in one >SQL statment. > >I am running mySQL. > >Keff > > >************************* >Proud user of Sambar for 4 Years >------------------------------- >Installed First Sambar server >December, 1998. >************************* ************************* Proud user of Sambar for 4 Years ------------------------------- Installed First Sambar server December, 1998. ************************* ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
