I have text wrap on a cell with lots of text and I use 'Alt Enter' to create new lines within the cell. I need to find the rows that exist in one table but not in the otherwith this condition:(prod_name exist in table1 and not in table2.prod_name ) AND(prod_name exist in table1 and not in table2.'S'+prod_name )explanation:i want to know if the product not exit and if the combination of thecharachter 'S' with the product Name also not exist at the other tableB.Ryuvi Try something like the following.SELECT T1.ProdNameFROM TableOne as T1 LEFT JOIN TableTwo as T2ON T1.ProdName = T2.ProdNameWHERE T2.ProdName is nullUNIONSELECT T1.ProdNameFROM TableOne as T1 LE. Default Standard, automatic setting.Need to know exist in one table and not exsit other Line spacing The amount of space between lines of text. Grammatical error These errors are underlined in green. Spelling error These errors are underlined in red. Template A document that contains formatting, styles, and sample text that you can use to create new documents. Style set A collection of styles that have coordinated colors and fonts. Style A collection of formatting options that can be applied to characters or paragraphs. Vertical alignment The position of the text in relation to the height of the page.
Horizontal alignment The position of the text in relation to the width of the page. Footer The type placed at the bottom of the document that will be repeated exactly on each subsequent page of the document. Header The type placed at the top of the document that will be repeated exactly on each subsequent page of the document. Zoom slider Feature used to magnify and reduce your document on the screen. View buttons Used to switch between views located at the bottom-left of the document window. Toggle Switching between two options by clicking the same button. Status bar Displays information about the current document and process.
0 kommentar(er)
