Posts by Berkson • 33 points
2 posts
-
1
votes2
answers485
viewsA: Create a temporary table or run a 4 table Join with some more fields than others
So I solved my problem. If anyone has any improvement to do in the consultation, I accept advice. Personal thanks. CREATE view todas_as_cis AS SELECT cis.numci, u.nome, cis.id, i.tipoci, i.id_user,…
-
1
votes2
answers485
viewsQ: Create a temporary table or run a 4 table Join with some more fields than others
I have five tables, cis with the fields id, id_referencia, tipoci and numci, the others are cigeral, ciintercambio, cihoraextra and cicompensacao. When I create one of the cis give a insert in the…