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
    Forum Police Guest

    Default *** CROSS POST ***


Posting Permissions

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