Posts by Mabner • 11 points
2 posts
-
0
votes1
answer730
viewsA: Select connecting 3 tables in Firebird with different Ids
I managed with the code below. What was missing was to specify the JOIN of the table TB_EST_PRODUTO as LEFT. select ident.id_identificador, est.id_estoque, est.descricao, est.prc_venda,…
-
0
votes1
answer730
viewsQ: Select connecting 3 tables in Firebird with different Ids
Good afternoon, I need to make a select that returns to description of the product,barcode and price. The description and price are in one table (TB_ESTOQUE) and the barcode is in another…