Friday 15 February 2013

mysql - INER JOIN error -


After

I want to join and enter the inner error getting the bellow:

# 1064 - You have an error in your SQL syntax; Check that the manual that is close to using the right syntax to check your corresponding server version is 7

  Select 'Internal JOIN' at Cuspoit.`Cuspoit_partno (Chalanits.Chalanit_partno, run Choose Chalanits.Chalanit_qty from '', 'QiSipot_InitPrice', 'Chalikat', 'Cosipit' from Chalinat, where 'COOPIPIT'. 'COPYIPTICUS PAD' = (Solid Cholants, Chalinite_cosospoide for swamps, where running.Chalinite_chalined = 'CX-1306001' Border 1) Inner Joie (Solid Challenges.) Walked_Parto, Chalacates Can anyone help me find fault ??          P>      Selection Cuspoit.`Cuspoit_partno`, Cuspoit.`Cuspoit_unitprice`  
 : / div> 

that use SQL, Chalanits.Chalanit_qty Cuspoit from within (Chalanits.Chalanit_partno, Chalanits.Chalanit_qty joining Chalanits Choosing Chalanits.Chalanit_chalanid = 'CX-1306001') on Cuspoit.Cuspoit_partno` = Chalanits.Chalanit_partno WHERE Cuspoit.Cuspoit_cuspoid` = (Select Chalanits.Chalanit_cuspoid from Chalanits where chalanits.Chalanit_chalanid = 'cx - 1306001 'Border 1)

Where are you inverted and join the inner comand

No comments:

Post a Comment