Mythreyi's Page

"Suresh, Its very nice, im looking it for past few weeks."

"Use print statement syntax:print variablename or "constant" Thanks, Manu"

"print option is there "

"Hi Raja....   There in no Alert Function in VB Script okay.   "

"Hi we can use Windows shell Script Advantage of this Script is it's time delay Msgbox. '----------------------------------------------------------------------------------------- Dim oWsh Set oWsh =…"

"mysql> SELECT * FROM officeTable WHERE Empid in(SELECT Empid FROM employee); is this what you are looking for?"

"Hi, nice explain. Between join, sub query & nested query, who will give fast result?"

"Hi Arvi, I have idea about join but few doubts regarding this - Inner join, euai join and Simple join is same? because oracle support simple join while SQL server ,MySQL support Inner join. Please clear it . Thanks Hitesh "

"Hi, Please follow the following steps i hope it works:   1) Click the Data Table option from the toolbar 2) Now Right Click the Data Table and select Import a file 3) You can Select the Path of the file to be imported. 4) After the File is…"

"I am getting the same error , it works sometimes and it doesn't getting general error please help"

"yes now i remember there are different syntax for same queries but both are joins weather he used join or not.i think subquery is the right answer."

"Using Alias - Implicit joins Using Joins - Explicit joins Both are joins only, but different join notions. The only way to retrieve from 2 tables is using sub queries. I have specified  the query above."

"  With Alias - we can alias a name to a column or table and retrieve the data from 2 tables. Joins- We can retrieve data from more than 2 tables.   With Alias also we can retrieve the data then why we use Joins? pls.. explain clearly. Bcoz…"

"Thanks Samrat, my bad. I had written the queries using implicit and explicit joins. But, the point here is not about Theta / ANSI styles definately. JFYI, I have provided the query to retrieve data from 2 tables without using joins in a…"

"you can try something like this though...   Select emp.ename, dept.dname from emp, dept where emp.eno in (Select eno from emp)"