The last two entries in the cell are not wrapping though the first four entries within the cell wrap just fine.Is there a way to get the last two entries within the cell to text wrap?Thanks! Is the rowheight big enough?And if those last two entries are really long, then maybe a few more alt-entersto break them up?Craig wrote:> I have text wrap on a cell with lots of text and I> use 'Alt Enter' to create new lines within the cell. 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. Need to know exist in one table and not exsit other
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |