anyone see whats wrong with this??

Results 1 to 2 of 2

Thread: anyone see whats wrong with this??

  1. #1
    Join Date
    Dec 1969

    Default anyone see whats wrong with this??

    SELECT, tblproject.jobno, tblproject.proOp, tblproject.client, tblClients.Coname, tblproject.Projname, tblproject.BusCat, tblbusiness.buscatgy, tblproject.ProOpdate, tblemployee.empid, tblemployee.fname, tblproject.Projdes, tblproject.Val, tblproject.Startdt, tblproject.Enddt, tblproject.Prob, tblproject.Active1, tblemployee.sname, tblproject.archive<BR>FROM (tblbusiness INNER JOIN (tblClients INNER JOIN tblproject ON tblClients.Coid = tblproject.client) ON tblbusiness.catid = tblproject.BusCat) INNER JOIN tblemployee ON tblproject.empid = tblemployee.empid;<BR><BR>this works fine in access but pasted into mySQL it doesnt like it .... there seems to be a problem with the inner join - is there a different syntax used in mysql???<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: anyone see whats wrong with this??

    Hope it will help:<BR>SELECT, tblp.jobno, tblp.proOp, tblp.client, tblC.Coname, tblp.Projname, tblp.BusCat, tblb.buscatgy, tblp.ProOpdate, tble.empid, tble.fname, tblp.Projdes, tblp.Val, tblp.Startdt, tblp.Enddt, tblp.Prob, tblp.Active1, tble.sname, tblp.archive <BR>FROM tblbusiness tblb,tblClients tblC,tblproject tblp,tblemployee tble<BR>WHERE tblC.Coid = tblp.client and tblb.catid = tblp.BusCat and tblp.empid = tble.empid; <BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts