wood burning stoves*
The moose likes Struts and the fly likes how to write sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "how to write sql query" Watch "how to write sql query" New topic
Author

how to write sql query

smitha mano
Ranch Hand

Joined: Sep 26, 2005
Posts: 70
--------------------------------------------------------------------------------
Emp.table

id name Desig
1 aaaa SA
2 bbbb PL



Address.table

id street CITY
1 Pulluvazhy Perumbavoor
2 Kizhillam Pulluvazhi



i wanted to retriev data

Desig =PL the city=pulluvazhi
David Ulicny
Ranch Hand

Joined: Aug 04, 2004
Posts: 724
select e.id,e.name,e.desig from emp e where e.desig='PL'

for table address table it will be the same


SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to write sql query