Contrary to popular belief, working on documents online can be hassle-free. Sure, some file formats might seem too hard with which to deal. But if you get the right solution, like DocHub, it's straightforward to tweak any file with minimum effort. DocHub is your go-to tool for tasks as simple as the option to Select Table Release For Free a single file or something as daunting as dealing with a massive stack of complex paperwork.
When considering a solution for online file editing, there are many solutions on the market. However, not all of them are powerful enough to accommodate the needs of individuals requiring minimum editing capabilities or small businesses that look for more extensive set of features that enable them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing paperwork online more streamlined and easier. Try DocHub now!
im going to discuss about how to select all record from one table that does not exist in the another table okay so we need to do that so here both table has the department id if the department id both are matching one table second table that record wont be display and except that that display the record so lets see how to do that so first using select is select and do here star then from so there im going to use the hr table hr if you press the dot then you can get the list of tables are there so implies okay and the next table that im going to use select star from hr dot and here departments now lets execute this two queries so now you can see here this is department id and department id if both are the same if 10 percent in our department id of employees then then that not be displayed except that 1090 whatever the matching department id that do not display except that that display so for this one lets write the queries so first im going to copy so now here you can see selec