Jump to content

fonecave

Members
  • Content Count

    61
  • Joined

  • Last visited

Community Reputation

0 Neutral

About fonecave

  • Rank
    Regular Member

Contact Methods

  • MSN
    andynewham@hotmail.com

Profile Information

  • Gender
    Not Telling
  1. Perfect thank you so much I think the main problem was case sensitivity but thanks for all your help
  2. Hi Guys, I have a JET SQL query that i need to convert to MYSQL (Appologies too if this is posted in the wrong section.. i never know whether to go PHP or MYSQL!) Im not being lazy.. ive tried for hours but cannot get it to work, it has two depth inner join and a group by with a where (with 1 criteria)... If anyone can help id massively appreciate it and also explain how you got there... SELECT Count(tbl_Items.ItemID) AS CountOfItemID, tbl_LU_Collections.CollectionDesc FROM (tbl_Items LEFT JOIN tbl_LU_Categories ON tbl_Items.ItemCategory = tbl_LU_Categories.ItemCatID) LEFT JOIN
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.