How to write a Sql statement without using union? -
I have a SQL statement like below. How do I add a line (code = 0, dead = 1) to the result of this SQL statement without using the union keyword? Thank you.
Select the code, content from the content where the content ExpireDate = '2010/07/23'
You always create a view for your table
create visual content_selected as code, character, content union Choose end to '0', '1', tap; Select code, WHERE end date = '2010/07/23' or code = '0' from content_view;
Comments
Post a Comment