|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 10th, 2003, 01:28 AM
|
|||
|
|||
|
Searching For than One Table
Hie,
I want to search for UserID in 3 table. Searched UserID wil be present in one of any 3 table. Using select * from <table> where UserID = < =userid> allows me to search in only 1 table Is there any way .. to join 3 tables and search for the UserID using single SQL Query Thanx a lot for reading my query 
|
|
#2
August 11th, 2003, 09:31 AM
|
||||
|
||||
|
You can add more tables to your query by separating them with commas.
Code:
SELECT * FROM table1,table2,table3 WHERE query
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Searching For than One Table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
