[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