select do mal

[lefestaf 0]

seguinte, preciso fazer um select que envolva 3 tabelas, mas ja tentai com inner join, left outer join e nada, alguem poderia me ajudar??

 

$sql = "SELECT cad.ID AS cadID, cad.Nome AS cadNome,cad.Razao_social AS cadRazao, 		cad.RG AS cadRG, cad.CPF AS cadCPF, cad.IE AS cadID, cad.Tipo AS cadTipo, 		cad.CNPJ AS cadCNPJ, con.ID_cad AS conID_cad, con.Tel AS conTel, 		con.Cel AS conCel, con.Email AS conEmail, con.Site AS conSite, con.Tel2 AS conTel2, 		con.Fax2 AS conFax2, con.Email2 AS conEmail2, end.ID_cad AS endID_cad, end.End_comp AS endEnd_comp, 		end.Numero AS endNumero, end.Complemento AS endComplemento		end.CEP AS endCEP, end.Cidade AS endCidade, end.Estado AS endEstado, end.Tipo AS endTipo 				FROM cadastro cad 			INNER JOIN contatos con ON cad.cadID = con.conID_cad 				INNER  JOIN enderecos end ON con.conID_cad = end.endID_cad 				WHERE cadID = $id";

[etapombas 0]

Genti que rolo....Tenta resumir mais o códigoSELECT A.*, B.*, C.* FROM cadastro A, contatos B, enderecos C WHERE ...

[lefestaf 0]

ja achei a solucao!!! tinha alguns erros de sintax!!!