include ("conexao.php"); $SQLMarca = "SELECT TOP 100 PERCENT dbo.TB_Marca.marca_id, dbo.TB_Marca.marca_descricao FROM dbo.TB_Marca INNER JOIN dbo.TB_Modelo ON dbo.TB_Marca.marca_id = dbo.TB_Modelo.marca_id GROUP BY dbo.TB_Marca.marca_id, dbo.TB_Marca.marca_descricao HAVING (dbo.TB_Marca.marca_id = 87) ORDER BY dbo.TB_Marca.marca_descricao"; $execMarca = mssql_query($SQLMarca); $row = mssql_num_rows($execMarca); ?>