[thelist] Regarding SQL query

Joshua Olson joshua at waetech.com
Tue Nov 20 09:56:10 CST 2007


> -----Original Message-----
> From: Mohit Kumar Chauhan
> Sent: Tuesday, November 20, 2007 10:48 AM
> 

> It multiplies the columns of HELP_TABLE and HELP_DETAILS 
> table and gives
> the result. what should I do to get ht1.HELP_ID corresponding to
> hd.HELP_ID Without multiplying the rows?


Mohit,

Your best course of action would be to get a bit more information on the
JOIN syntax.  Here's a possible place to start:

http://en.wikipedia.org/wiki/Join_(SQL)

Joshua 





More information about the thelist mailing list