Posts by Diogo Fernandes • 39 points
2 posts
-
0
votes1
answer37
viewsQ: CTE: Union of two tables in which one of them has only one field in common
I need to do the following using a CTE.Imagining two tables with columns: Articles: Reference, Quantity, Price Associated References: Reference, Referral I intend that if there is an associated…
-
3
votes2
answers171
viewsQ: Select within select where condition exists
Good morning, With a table of articles with the fields Reference | Quantity | Price | Referencesociated | I wanted to have a select that would do the following, with the example: Example Table of…