I'm doing a search where the user enters the order ID and the system does return the request's observation, product code and qtd. And these data are arranged in 2 tables. (I did not create the bank, it already came ready) However, with my query using innerjoin the console says the search is ambiguous. tb_ped_venda is where is the quantity and the id of the products tb_pedido_venda is where the order submissions are.
SELECT TB_PED_VENDA_ITEM.ID_IDENTIFICADOR,
TB_PED_VENDA_ITEM.QTD_ITEM,TB_PEDIDO_VENDA.OBSERVACAO
FROM TB_PED_VENDA_ITEM INNER JOIN TB_PEDIDO_VENDA
ON TB_PED_VENDA_ITEM.ID_PEDIDO = TB_PEDIDO_VENDA.ID_PEDIDO
WHERE ID_PEDIDO=$id"